April 4, 2008 at 2:43 pm
Hi there. Well, I've tried the approach in these forums (and on Technet) to add a role-playing dimesion to my cube. But when I try to filter on one of the role dimensions, the dataset shrinks to the filtered set.
One dimension, dimProgram lists all TV programs. I added a new role dimension called dimFilterProgram and linked to factProgram on the dimFilterProgramID key. The dimProgram dimension is linked to the dimProgramID. I want to see what all people who watch say American Idol (selected in the dimFilterProgram dimension) also watch. I filter on programName = American Idol using the dimFilterProgram dimension. Then I try to browse all the other programs using the dimProgram dimension. But, guess what- only American Idol viewers show up in the cube. Somehow the cube thinks these are the same.
Do you have any idea what is going on or how to fix?
Thanks,
Ben
April 15, 2008 at 12:59 pm
You are not understanding how filters work in a cube.
Any time you filter data in a cube, you filter the entire fact set.
All filter conditions will result in an AND condition.
It sounds like what you are trying to do is get a list of members in one dimension that are associated to a member in another dimension by at least one fact. You then want to get the list of all facts associated with this member list.
Some cube browsing UI's will allow you to do this by simply following those steps, filter by one dimension member, drag your other dimension into your pivot table, select all of the visible members and filter by them, and then un-filter your first dimension.
As an alternative, if this is a very commonly run query, you could create a fact table that associates your two dimensions together and then use a many-to-many relationship in the cube.
April 15, 2008 at 3:43 pm
Gotcha. Thanks very much for clarifying that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply