DAX Performance problem

[fsabbagh]

[FONT=&quot]Hi,[/FONT]
[FONT=&quot]Have a traditional star schema Kimball Tabular model in SSAS. There are 2 fact tables. GeneralLedger and GLBudget.[/FONT]
[FONT=&quot]

[/FONT]
[FONT=&quot]I've been encountering a timeout every time with the Summarizecolumns command below. I took out the measures below and still get the timeout. If I remove the BP dimension, it works. Why? SQL Server 2017 running under Windows Server 2016 with 64 Gig RAM. DB is 5 gigs. There is nothing else serious on the server running since it is my Dev server.[/FONT]
[FONT=&quot]EVALUATE SUMMARIZECOLUMNS ([/FONT]
[FONT=&quot]'Company'[Company], 'Company'[CompanyName], 'GLPlant'[GLPlant], 'GLPlant'[GLPlantDesc], 'Account'[Ledger], 'Account'[LedgerDesc], 'GLDept'[GLDept], 'GLDept'[GLDeptDesc], 'FiscalCalendar'[CorpFiscalYear], 'FiscalCalendar'[CorpFiscalPeriod], 'BusinessPartner'[BP][/FONT]
[FONT=&quot])[/FONT]
[FONT=&quot]Does anyone have any suggestions with the following DAX command. I thought SUMMARIZECOLUMNS was the new and improved command. Is there a limit to the number of dimensions we can query?[/FONT]
[FONT=&quot]Thanks,[/FONT]
[FONT=&quot]FerrisWheel[/FONT]

 

[Matt Allington]

Are you using best practice here? Ie are these all columns or are some of these measures? Can you post an image of the Data model? This statement doesn’t mean anything without the table design.

 

[fsabbagh]

Thanks for the quick reply Matt. This is the model. The list above are of the dimensions and fact tables. I did not include any measures in the Summarizecolumns command in the example above but it still times out when I do.

 

[fsabbagh]

sorry, can't figure out how to get my model out of SSAS. Used Snippet but can't paste here. Anyways, basically the 2 fact tables (General Ledger and GLBudget) are surrounded by the rest above which are dimensions.