I have a Fact table based on a View. Rather than create a Calculated Measure in the front-end BI application (Tableau), I decided to alter the View to include an extra column based on a CASE statement.
It occurred to me subsequently that I could have left the View untouched and instead replaced the View with a Named Query in the Data Source View.
My question is: which method is preferred? Does it depend on data volumes?
I know that you can't use Named Queries in a DSV if the cube storage mode is ROLAP, but that's not an issue because I'm using MOLAP.