Aggr expression in load script

[Anonymous]

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,',')

[hector_munoz]

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

[Anonymous]

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?

[Anil_Babu_Samineni]

You may send application so then we came to know what you would and what changes you need

[Kushal_Chawda]

this expression looks like, giving % values, why not to move it in expression instead of calculated dimension?

[Anonymous]

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