March 13, 2009 at 12:55 pm
Hello,
I am trying to figure out how to filter (hide) a dimension member.
As you can tell from the picture, unknown member rolls up under term "0". I want it to be not visble on the front end. I did set the "unknown member" property to "Hidden" and reprocessed the qube, but it didn't work.
Looking at the attached picture, I tried to use filter member and tried to filter out unkown, but it seems like it does a select statement with "and" between two entries. I couldn't find a way to select terms from 1999 - 2012.
Can someone plese guide me.
Thanks.
Ravi.
------------
🙂
March 13, 2009 at 2:06 pm
How is your DSV defined? A table selection or a query?
Personally I'd use the query in the DSV to remove any records like those before it even reaches the dimension.
March 16, 2009 at 7:06 am
I thought about using DSV to filter it out, but I can't use DSV because these rows need to be counted in totals. I really need to filter them out at the end when everything is counted.
My organization has weird rules about seeing data, and the person who is requesting this change is pretty anal.:crazy:
------------
🙂
March 16, 2009 at 9:28 am
I have to admit that this seems a little confusing. You need the 0 term rows counted but then the data must not be displayed to the end user?
It you don't mind my asking what is the row count used for?
If the count of the zero entries isn't being used I'd use the default cube partition to add a where clause that filters out the zero term rows.
At least that way your dimension remains in tact and the cube only shows the valid (1999-2012) term information.
I feel your pain on the anal end users. Not good for the blood pressure.;)
btw the filter method you used on the screen shot works more like an excel autofilter. Lets you see the values of the dimension in a way that makes it easier for you. It doesn't affect the dimension output.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply