Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with 15 dimension and one expression which shows the URL , the table has 10k rows the load time really slow , can I know why ? 10k is not really a large data set right ?
Open the Document Properties, go to Sheets, select the sheet where your problematic table is located, and then select the object (table) in the lower box. What does the CalcTime and Memory show? Is the memory greater than the available system resources?
The 10k rows are the result of calculations involving 15 dimensions (which is quite a lot for a chart) and an unknown number of records. Your data model could have millions of rows involved in the calculation of the expression results. Your data model could be very complicated with dozens of tables associated in a extremely snow-flaked model.
Can you please show us a snapshot of your data model. As gwassenaar have said, it could be the complexity of your data model that slow it down your loading time
My data model if a concatenation of 6-7 tables .. is that the reason for slow ness?