Data action not working SAP ANALYTIC CLOUD

[S0020706010]

I have the following data action configured:

MEMBERSET [d/CONCEPTO] = ("VENTA_NETA")

MEMBERSET [d/ORG_VENTAS] = ("2000")

DELETE([d/METRICA]="TONELADA")

DATA([d/METRICA]="TONELADA")=

RESULTLOOKUP([d/METRICA]="FC_TON") * RESULTLOOKUP([d/METRICA]="CANTIDAD") *0.001

As you can see, you must multiply what is in the metric FC_TON * the metric amount * 0.001.

When it executes the data action, I proceed to enter the parameters that it has configured

Clic Run

The data action does not throw any error and ends correctly, but it does not perform the calculation on the tons metric. The only strange thing I see is that the data is in different rows.

How can I solve this problem?

[chia-yu_wu]

Hi @abcds,

did you try to Add an extra MEMBERSET on the dimension in the first row?

The reason my be that the metric FC_TON * the metric amount is calculated in the child level and not on the mother level?

Cheers,

Would be happy for your feedback 🙂

Chia-Yu

[S0020706010]

Hi Chia-Yu-Wu

Thanks for your answer.

If I try to add the MEMBERSET to the first Row the code looks like this.

MEMBERSET [d/CONCEPTO] = ("VENTA_NETA")

MEMBERSET [d/OFI_VENTAS] = ("NA_T")

MEMBERSET [d/ORG_VENTAS] = ("2000")

DELETE([d/METRICA]="TONELADA")

DATA([d/METRICA]="TONELADA")=

RESULTLOOKUP([d/METRICA]="FC_TON") * RESULTLOOKUP([d/METRICA]="CANTIDAD") *0.001

The result I expect is in the metric TONELADAS show me the result of the operation FC_TON * AMOUNT * 0.001

But when it executes the data action it ends without errors but it does not show me the result of the operation, what do you advise me to solve this problem.

Tks,