Implement sum({1< ProductName=P(ProductName) >}Sales) at script level

[bhaskar_sm]

Hi All,

I would like to know is there anyway, to create the flag at the backend for ProductName which does the same job as given below sum({1< ProductName=P(ProductName) >}Sales).

Any help is highly appreciated 

Thanks,

[lorenzoconforti]

Do you mean a flag in the load script? If that's the case, by definition set analysis is utilised on the front end so not sure I understand the requirement

Can you please explain in more details?

[bhaskar_sm]

Yeah, Flag in the load script,  on the front end we do have a very long-expression like this 

Universe=p(Universe),
FamilyName=p(FamilyName),
StoreName=p(StoreName),
StoreCity=p(StoreCity),
ZipCode=p(ZipCode),

which comes from different dimensions tables.  by using P() functions, application response time is poor. 

[lorenzoconforti]

I am not sure of how you would implement this

Again, p() is purely used in the front end because it retrieves all the possible values from another set. By definition, there are no sets during load as it is purely a front end implementation as it's linked to users making selections

If you give more details on the expression maybe a different solution could be found