topic Re: Implement sum({1< ProductName=P(ProductName) >}Sales) at script level in App Development

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

bhaskar_sm — Sat, 16 Nov 2024 18:44:14 GMT

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,

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

lorenzoconforti — Fri, 24 Apr 2020 17:28:55 GMT

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?

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

bhaskar_sm — Fri, 24 Apr 2020 17:50:53 GMT

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.

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

lorenzoconforti — Fri, 24 Apr 2020 18:09:01 GMT

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