how filter dimension attribute data in SSAS Cube

• VRT

  SSCertifiable

  Points: 5776

  More actions

  July 26, 2011 at 3:17 am

  #240571

  Hi,

  I have a cube.

  I have a attribute region in location dimension.

  when I select region attribute in Browser tab of Location Dimension file Location.dim, it will be showing two items

  US

  Non-US

  I don't want Non-US region. I am using Member filter but it didn't work. After refresh it's again coming to two items.

  please help me.

  Thanks.

  Thank You

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  July 26, 2011 at 5:01 am

  #1358361

  do you have the correct attribute relationships setup?

• VRT

  SSCertifiable

  Points: 5776

  More actions

  July 26, 2011 at 6:30 am

  #1358442

  Hi

  Yes I applied attribute relations correctly.

  Actually, I used named query in DSV file, we have location_code column based on that column I wrote a case statement.

  Thank You