Post reply

how filter dimension attribute data in SSAS Cube

  • 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

  • July 26, 2011 at 5:01 am

    #1358361

    do you have the correct attribute relationships setup?

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply