Post reply

Filtering cube from value on a fact table

  • February 25, 2013 at 5:32 am

    #149747

    Hi all,

    I'm posting here cause my research didn't help me at all 🙁

    I'm lookig to filter data via a role in SSAS.

    I have a fact table, with a column "valid" (0 or 1) wich is linked to dimensions tables. I want to use a role in SSAS to filer the data using this column.

    I saw that I can filter the dimensions, but didn't see if it's possible to do it with the fact table... Maybe using MDX? But I don't know where to do that.

    any inputs would be appreciated!

    thanks in advance

  • February 25, 2013 at 9:27 am

    #1590850

    Why not create a "Valid" dimension that is hidden from the users and base your security of that?

    Mack

  • February 25, 2013 at 9:50 am

    #1590857

    yes, that's what I was thinking... I asked because I didn't know (still don't know) if it's possible to to this without dimension!

    thanks for your reply

  • February 25, 2013 at 9:55 am

    #1590859

    A dimension will be the quickest way as it will continue to use aggregations across your data. If you try to limit the data against a low level data item then the cube will have to go to that low level for every query and that would affect performance

    Mack

  • February 25, 2013 at 10:19 am

    #1590875

    perfect answer! thanks a lot Mack!

Viewing 5 posts - 1 through 4 (of 4 total)

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