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