I made a report combining two queries. Q1 retrieves all items, Q2 retrieves
items with associated dimensions and measures.
Then I set a filter on one dimension and on one measure from Q2 on #EMPTY
values, to display all existing items without information on these
dimension and measure. It works fine.
But when I close and re-open my report, BO displays no row. I need each
time to remove and add again the filter on the measure.
Has anybody encountered such a problem ?
Christophe,
I have seen this before. Don't know why is doesn't work, but the easy
workaround is to define a new variable with the syntax 'if
IsNull(<Q2_Object>) then "Y" else "N" '. Then filter on the new
variable value. It will stay set even after closing.
Jason Beard
I made a report combining two queries. Q1 retrieves all items, Q2 retrieves
items with associated dimensions and measures.
Then I set a filter on one dimension and on one measure from Q2 on #EMPTY
values, to display all existing items without information on these
dimension and measure. It works fine.
But when I close and re-open my report, BO displays no row. I need each
time to remove and add again the filter on the measure.
Has anybody encountered such a problem ?