Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a detail sheet with almost 20 columns, the sheet has around 4m records , but if I select a subset (10k records) from the main sheet and go to the details sheet, still the load is taking longer. Any suggestions.
The datamodel doesn't have any synthetic keys and all the calculations are done at the database level.
are you also using heavy set analysis statement within you measures?
also, are you using extensions in the sheet you are referring to?
I am not using any set analysis or extensions.