SSAS – Calculation in DSV or in view from data source


This wasn't an easy question to Google, a lot of word overlap.

My table has a column with a date. I'd like another column that is a calculation on that date. I can do this with a Named Calculation on the dsv. Or, I could do this in the view from the data source that feeds this table into SSAS. Trying to figure out which would be better.

This calculated column will be for a dimension attribute.

Best Answer

Adding calculations either in DSV or in a view do not have much difference, it is just a choice, where you wish to maintain your SQL code. You can take a decision based on, which approach is best suited for you, from maintenance point of view.

following link can be helpful: