topic Re: Managing dynamically expressions regarding the dimension in App Development

Managing dynamically expressions regarding the dimension

ramon1 — Fri, 25 Mar 2022 14:38:54 GMT

Hello,

On a pivot table (on Sense), I have a list of kpi's names (in a island table) , for each one I need to calculate yearly value (col1), average (col2) etc...

So, on each expression, I have a collection of "if" like :

if( kpi=aa, [master item1], if kpi=bb, [master item2] and so on

You can easily guess that the performance isn't great. Is there any way to avoid this kind of expression ? ( I tried expression stored in a field of the kpi table, variables with the same name of kpi etc... )

The best would be an expression like [ master item 'name of dim1' ] or =$(=var_ name of dim1)

The table is exactly how users want to see it

Re: Managing dynamically expressions regarding the dimension

SunilChauhan — Mon, 28 Mar 2022 06:48:07 GMT

Load in Excel as two column KPI Name and expression.

Load Using Loop like below

Var:

LOAD KPI ,

Exp

FROM

filename.xlsx

Let vNoOfVar = FieldValueCount ('KPI') ;
For i = 0 to $(vNoOfVar )-1

Let vKPI = Peek('KPI',$(i),'Var');

Let $(vKPI ) = Peek('Exp',$(i),'Var');

Next i

Drop Table Var;