I am using ssas tabular on a major project and I have noticed something both disturbing and weird.
Basically I have many SSRS reports that read from a Tabular Cube; there I noticed that if I use calculated measures defined in the cube in my queries they become *really really* slow, but if instead; I take exactly the same code as the measure and embed
in my dax query it replies instantly.
Now if I connect to the cube via excel, and use that same calculated measure, I do not notice any performance issues...
Does anybody have an idea on what would be the cause for this?
If I understanding correctly, the performance of using embedded calculations is much better than that using calculated measures in query, right?
Tabular models use Data Analysis Expressions (DAX), a formula language for creating custom calculations. Calculations are defined based on a combination of cube data, arithmetic operators, numbers, and functions using DAX. As per my understanding, the embedded
calculations were calculated while processing the database. However, the calculated measures in query will calculate the value while executing the query. So the performance is less than using embedded calculations.
If I have anything misunderstanding, please point it out.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.