Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table with 5 dimensions and an expression.
I have added 4 field dimension and 1 calculated dimension.
If i add all field dimension, then the pivot table shows data, if i add one calculated dimension like below
=Aggr(Only({<Date={">=$(=Date(MonthStart(AddMonths(Max(Date),-11)),'MMM-YY'))<=$(=Date(MonthEnd(Max(Date)),'MMM-YY'))"}>} Date),Date)
If i add the above expression in dimension, I am getting "Allocated memory exceeded" error, but if add Date as the dimension, then it works fine. What is the issue here?
Can someone please help me?
Hi,
I had added the similar Aggr expression in other pivot table, there it is working fine.
So i copied that pivot table and added this table dimension and expressions in that other pivot table and it is working fine. I don't know what is the problem with the pivot table.
I suspect that your date field has a time component as well, therefore it has a high cardinality and the vector created by Aggr() is massive (and running out of memory).
When you load the date, drop the time component or split out the time if you need the time value:
LOAD
...
...Date(Floor(SourceDateField)) As Date,
...Time(Frac(SourceDateField)) As Time, // if you need the time.
...
(Note the Date() function does not truncate the time part - it merely formats the value. You need the Floor() to do that)
This will simplify the Aggr() calculation.
Hi,
I had added the similar Aggr expression in other pivot table, there it is working fine.
So i copied that pivot table and added this table dimension and expressions in that other pivot table and it is working fine. I don't know what is the problem with the pivot table.