February 25, 2013 at 5:32 am
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
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
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
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
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