Skip to Content
1
Sep 10 at 04:11 PM

SAC -> Data Actions: Advanced formulas - Copy Measure Dynamically by Dimension Members

88 Views Last edit Sep 13 at 06:52 AM 3 rev

Hello SAP Analytics Cloud Experts,

Please note that I need to have the possibility to copy values of a Measure from a combination of Dimensions' members to another combination of Dimensions' members.

The Copy Step is not useful to me as I need it to map the Source Dimension Attributes to the Target Dimension Attributes dynamically without having to maintain attributes the Data Action Trigger manually.

Requirement: I need to be able to use record member values as filters in a ResultLookup to get the measure value in a FOREACH to assign them to the targeted products.(Or design a copy treatment via Advanced Formula)
Something like a Read statement in SAP ABAP.

As an example, here below is a table representing my model's transactional data

I need to use the Product_Source and Year_Source to pick up the Sales from their respective Product and Year. The sales values of the source product may changes during the day. The Data Action will be scheduled to be executed on an hourly basis

After the Data Action will be triggered, the sales value will be affected as below:

Here below is the Script that I tried on the Advanced Formula Step:

FOREACH.BOOKED [d/product], [d/year], [d/product_source], [d/source_year]


	DATA([d/measures] = "SALES", [d/product] = [d/product], [d/year] = [d/year] )= RESULTLOOKUP([d/measures] = "SALES", [d/year] = [d/source_year], [d/product] = [d/source_product])


ENDFOR

Can someone please help or advice me how can I make this treatment possible on SAP Analytics Cloud?

Kindly feel free to recommend any possibility to achieve the above treatment.

Thanks,

Kind Regards,

Jonathan Abel

Attachments

snap-1.png (14.8 kB)
snap-2.png (20.5 kB)
snap-2.png (14.3 kB)