I need to filter a dimension in a permanent way. The dimension represents the current status of transactions and I'm building a cube to be exploited by our customer. As you can imagine, I don't want them to see transactions that are in any status but "Approved". Is there a way to do this at SSAS level or do I have to configure it on the presentation tool?
You can filter the dimension by filtering the table in the data source view or you can create a View that sits on top of the table that you bring into the DSV. Either way works, but with the view you can make changes to it without opening the SSAS project.
My preference would be Dustin's option but you can also set a default member on the dimension so it's always implicitly filtering on Approved.