Another timely video for me. I've been using Best Practice Analyzer (BPA) in Tabular Editor to easily identify and disable columns isAvailableInMdx property. But now I will be more careful about disabling, and focus on larger size, and columns that won't be used in calculations. And I loved the #unplugged at 26:14.
Hi Marco, very interesting video ! What do you think about removing the hierarchy attribute from columns used in relationships ? In my DWH u always use surrogate keys and establish relationships in the model through those columns. Since all keys are identity columns, the hierarchy is quite large. Thanks for your suggestion Alberto
Please discuss the impact oh processing large partitioned model. Currently it takes same time to process one partition as it does to process all 10 year partitions
![[#2024MAMA] G-DRAGON - 무제(Untitled, 2014)+POWER+HOME SWEET HOME+뱅뱅뱅+FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/Ox29z5Nf1Uk/mqdefault.jpg)
Unplugged versions of videos are so good. Well done!
Another timely video for me. I've been using Best Practice Analyzer (BPA) in Tabular Editor to easily identify and disable columns isAvailableInMdx property. But now I will be more careful about disabling, and focus on larger size, and columns that won't be used in calculations. And I loved the #unplugged at 26:14.
Thanks for helping us to learn so much about DAX!
great insight, Marco! thanks for sharing.
Hi Marco, very interesting video !
What do you think about removing the hierarchy attribute from columns used in relationships ?
In my DWH u always use surrogate keys and establish relationships in the model through those columns.
Since all keys are identity columns, the hierarchy is quite large.
Thanks for your suggestion
Alberto
No side effects if they are used only in relationships and not in formulas.
@@SQLBI Thanks ! I'll go through the columns removing che SK first, and test both RAM savings & performance.
Please discuss the impact oh processing large partitioned model. Currently it takes same time to process one partition as it does to process all 10 year partitions
Thanks for the video Marco.
I thought tabular is running under the power bi, what is the business of 'MDX' In here?. Can you explain this.
When you use "Analyze in Excel" the queries are generated in MDX by Excel.
@@SQLBI thank you.