Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to implement the Pivot Table calculated dimension below in load script. I tried but could not. The pivot table was giving the 'allocated memory exceeded' error. Can somebody help me?
Num(Aggr(Count({<ERIDForFilter = {"$(vER1)","$(vER2)","$(vER3)","$(vER4)"}>} Distinct SubphaseNumber_vwSO), EngagementFile)
/
Aggr(Count({$<SignoffFlag -={""}>} Distinct SRNForFilter),EngagementFile)
*100,0)
Variables:
vER1 = SubField(vStoreEngagementRole,',',1)
vER2 = trim(SubField(vStoreEngagementRole,',',2))
vER3 = trim(SubField(vStoreEngagementRole,',',3))
vER4 = trim(SubField(vStoreEngagementRole,',',4))
vStoreEngagementRole = Concat(Distinct ERIDForFilter,',')
Hi Ranajit,
Everything is based in user selections:
vStoreEngagementRole = Concat(Distinct ERIDForFilter,',') are possible values (availables after some field selections),
vER1, vER2, vER3 and vER4 are the first 4 possible values
Why do you want you calculate the expression in script?
Regards,
H
I wanted to calculate the expression in script because this expression is a calculated dimension in the pivot table because I assume it is giving me the 'Allocated Memory Exceeded' and 'Out of object' errors. There are 3 other dimensions - all single fields.
In the Expressions, there are 9 expressions with calculations in Conditional and Definitions. Each expression represents an image that will show individual or multiple images depending on user selections.
Since there is only 1 Calculated Dimension, I assumed from my research in QV discussions and blogs, that this is most likely causing the error and implementing it in script and passing a field into the pivot table would fix the error.
Any thoughts on this?
You may send application so then we came to know what you would and what changes you need
this expression looks like, giving % values, why not to move it in expression instead of calculated dimension?
I resolved the issue. It was a field in the Expressions giving all values instead of selected values. I appreciate all you replies and help