Forum Discussion
Solved
Understanding the Vertipaq Engine
Hello I am doing a deep dive into the Vertipaq engine and I have a few questions regarding a concrete use case. I have a .pbix file with two Fact Tables: - Raw (300k rows and 17 columns) wit...
- Columns Hierarchies are internal structures storing a sorted textual version of the content of each column. It is required for MDX, and it is now used also internally for optimizing certain queries (in other words - we cannot get rid of it, even for columns we never use un MDX)
- See above - even numbers are converted into strings
- I don't understand the question - but VertiPaq Analyzer reports the memory consumption of the data model, whereas the size of the files could be different (serialization and additional structures).
I hope it helps!
Marco Russo - SQLBI
- Columns Hierarchies are internal structures storing a sorted textual version of the content of each column. It is required for MDX, and it is now used also internally for optimizing certain queries (in other words - we cannot get rid of it, even for columns we never use un MDX)
- See above - even numbers are converted into strings
- I don't understand the question - but VertiPaq Analyzer reports the memory consumption of the data model, whereas the size of the files could be different (serialization and additional structures).
I hope it helps!
Marco Russo - SQLBI
Dear Marco,
I hear you in this video sayng that is possible to disable Hier Size in SSAS, when not used, of course.
And now I can also see the green tickbox just on top, which makes me think that is really possible.
Could you be so kind to address me to some specific article where I can see how to do that?
Also let me thank you for all the availability, support and videos.
You are making a great job among PBI and Dax world! A Big thank you.