cancel
Showing results for 
Search instead for 
Did you mean: 

SAC - Data Actions - Advanced Formulas action

axel_
Participant

Hi Folks,

trying out data actions - advanced formulas and struggling a bit...

Intention:

Copy value of a account figure from on day to all other days of the year.

Code:

// Working
MEMBERSET [d/Account].[p/ID]= "G1000"
MEMBERSET [d/Time].[p/DATE] = ("20180101","20180102","20180102")

// Not working
//MEMBERSET[d/Time].[p/DATE] = "20180101" TO "20181231"
//MEMBERSET[d/Time] = "20180101"

FOREACH [d/Time]

// Not working at all
//DATA([d/Account]="G1000")=RESULTLOOKUP([d/Account]="G1000",[d/Time]="20180101")
DATA([d/Account]="G1000")=RESULTLOOKUP([d/Account]="G1000",[d/Time].[p/DATE]="20180101")
ENDFOR

Issues:

MEMBERSET does not recognize the day range with to

->Mismatching input 'TO'; expecting EOF

Nor a single day

-> Member not found

Also if I try quarter or year it tells

-> 2018 is no leave member.

In Resultlookup it seems I cannot use .[p/DATE]

-> Error Mismatching input 'd/Time].[p/DATE]

So I guess I use the wrong syntax for values for the [d/TIME] in general.

Can somebody post an example how to set a day range / use day in RESULTLOOKUP.

(search did not bring up any). Or tell me what I am doing wrong?

Thanks and best regards,

Axel

Accepted Solutions (1)

Accepted Solutions (1)

axel_
Participant

Found the solution accidently....

Correct format is

MEMBERSET[d/Time] = "2018-01-01" TO "2018-12-31"

will then work also for RESULTLOOKUP.
Former Member
0 Kudos

Nice functionality...i don't know that exist. Can be implemented for current dates?

Regards

JohnL
Product and Topic Expert
Product and Topic Expert

Hi guys,

This is documented here:
https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/afe93e3cf1414a7b8419baad11cc...

When used with Time dimension, can use TO key word:

  • MEMBERSET [d/TIME] = [d/VERSION].[p/BEGINNING] TO [d/VERSION].[p/ENDING

In order to use the attribute “Beginning” and “Ending” of Version dimension, they should be predefined in the Version dimension with certain date values. Then during Advanced Formulas’ run time, it will be replaced with time scope.

HTH

John

Answers (2)

Answers (2)

ALinetzky
Participant
0 Kudos

Thanks Axel, to use variable or prompt will be very useful

Regarding the same subject, when will improve to pass data between models?

It's nor possible fill a target dimension with the attribute of the source dimension, now

ALinetzky
Participant
0 Kudos

Dear Alex

I would like to know if is posible to pass parameter to an Advance Formula, could you solve it??

Regards

Ariel

axel_
Participant

Hi Ariel,

currently not possible to pass any paramter to an advance formula / data action.

SAP promised to provide something with next quartarly release cycle (QRC-3-2019) which is due in August.

See here for the feature request and update from SAP

https://influence.sap.com/sap/ino/#/idea/214740/?section=sectionComments

Best regards,

Axel