SSAS Filter field not working

• wizard.spin

  SSC Enthusiast

  Points: 154

  More actions

  August 22, 2013 at 8:59 pm

  #298072

  In the attached image you can see the Cube structure, Item Dimension, Hierarchies used in Item Dim,attribute relationship defined in Item dim+ the data in browser.

  We can see that 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 ?

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  August 23, 2013 at 1:47 am

  #1644266

  Please do not crosspost. It wastes peoples time and fragments replies.

  Original thread can be found here:

  http://www.sqlservercentral.com/Forums/Topic1487623-17-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP