Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a table like this -
90% of the time it shows Error Calculation Timed Out.
But as soon as I change my Dimension Inventory_6, it starts displaying value.
I have created Inventory_6 in my data load editor as -
'Budgeted Inventory FY '&Right(Fiscal_Year_Inventory_MonthStart_Date,2)&'-'&Right((Fiscal_Year_Inventory_MonthStart_Date+1),2)&' (for the month)' as [Inventory_6].
The variables which I have used in Inventory_6 are working totally fine.
Could you elaborate more on your issue
There is a dimension Inventory_6 and rest are measure.
It shows as Out of memory error in the table.
As soon as I remove my dimension and place a normal dummy dimension it works perfectly.
You either need to
1) optimize your data model
2) optimize your expressions
3) both of the above
Refer this article