Tableau has been able to add Calculated Members to an “old school” SSAS cube for a while. Can it do the same thing against the a Tabular Model?
Yep. But it’s not quite as straight forward.
Let’s say I want to add a custom member called [Places I Like] to the sample AdventureWorks Tabular Model. I do this in Tableau:
When I attempt to use the [Geography].[Country Region Name] Dimension against the [Internet Sales] measure, SSASTabular throws the following exception, and hoses Tableau:
Analysis Services database error 0x80004005: MdxScript(AW Tabular) (9, 55) Calculation error in measure ‘Internet Sales’[Internet Total Sales]: The expression invokes an object that was defined by using an MDX calculated member or script. Such objects are not supported in DAX expressions.
