on 08-30-2018 7:56 AM
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
Found the solution accidently....
Correct format is
MEMBERSET[d/Time] = "2018-01-01" TO "2018-12-31"
will then work also for RESULTLOOKUP.You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Alex
I would like to know if is posible to pass parameter to an Advance Formula, could you solve it??
Regards
Ariel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
75 | |
10 | |
10 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.