Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS Filter field not working Expand / Collapse
Author
Message
Posted Thursday, August 22, 2013 9:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 24, 2013 6:30 AM
Points: 2, Visits: 5
In the attached image we can see the Cube structure, Item Dimension, Hierarchies used in Item Dim,attribute relationship defined in Item dim+ the data in browser.

While browsing data and applying filter at the filter field we are not getting the appropriate result.

Note :
Amt Cat : Amt at the Item Category level (using calculated measure shown below)
iif(isempty([Measures].[AMT])=true, null,([Measures].[AMT],ancestor([Item].[Items].CurrentMember,[Item].[Items].[Item Category])))

Amt Grp : Amt at Item Group level (using calculated measure shown below)
iif(isempty([Measures].[AMT])=true, null,([Measures].[AMT],ancestor([Item].[Items].CurrentMember,[Item].[Items].[Item Group])))


But by applying the filter at filter expression we get the required result and even by modifying the attribute relationship as shown above we get the appropriate result.

Can anyone explain why is this happening so ?


  Post Attachments 
Cube.jpg (7 views, 378.74 KB)
Post #1487623
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse