on 05-04-2020 4:36 PM
Hi Experts,
We already have a drill through report in place for S/4 custom AO report based on a CDS. Now, the ask is to drill through from parent member in BPC to the AO report. The challenge we are facing is the AO report parent member format is different from SAP BPC member format.
To illustrate further: in BPC we have GL parent member as BA01JP1717, however, in the CDS view we have the GL parent member as BA01/JP1717. Whenever we try to map the field, the member is not recognisable in the AO report.
Our ask is there a string or formula we can use in Value column in Drill through to make it identify the field BA01/JP1717 not pass the just the BA01JP1717.
Apprciate your help!
System: BPC 11.1 BW/4 HANA
System: S/4 HANA 1709
Regards,
Deepak
Hi Vadim,
Thank you for responding. '%252F is not fetching any result as well.
We are almost through on the second option of maintaining a property called 'Drill Through' for the parent members on the Account dimension.
All we now want is to map the field in the master data upload process.
We want the parent node to look like "BA01/0JP1717" and base level to look like "T2A/9999999999" on the drill through property.
Please correct us if the below syntax is correct ?
*Mapping
DRILL_THR=*IF(ID(1:4) =*STR(BA01) THEN *STR(BA02/0) + ID ;*STR (T2A) + ID)
Appreciate your response!
Regard,
Deepak
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, but you mapping:
*Mapping
DRILL_THR=*IF(ID(1:4) =*STR(BA01) THEN *STR(BA02/0) + ID ;*STR (T2A) + ID)
Do not match your requirement:
"We want the parent node to look like "BA01/0JP1717" and base level to look like "T2A/9999999999" on the drill through property."
Unable to understand your logic...
Screenshot of BW hierarchy in RSA1 please...
Your current transformation and conversion file, please!
Try to use the property containing:
BA01%252FJP1717
After URL decoding "%252F" will result in "/"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
Thanks for your response. Unfortunately %2F is not helping the cause.
The other option is we are trying to have separate property in Account dimension and pull the parent member in the master data transformation file and then link the property on the drill through, we did try for one node and it works. Now on the transformation file, we want *string the parent ID + node name+ technical ID of the CDS view.
How can achieve using the below in the transformation mapping. The transformation file is not accepting '+', '/' , '()' chracters,
a. Value = + b. LEFT(5) = NA02/ c. Add Zero = 0 d. Node name starting after / = JPG1717 e. Constant = (2CIFIGLACCOUNTHNT) 1. For Individual accounts a. Chart of accounts = T2A/ b. Account id = 6171700001Appreciate your help.
Regards,
Deepak
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"and then link the property on the drill through" - can you post the resulting URL with the parent BW id in the property like: BA01/JP1717
"a. Value = + b. LEFT(5) = NA02 / c. Add Zero = 0 d. Node name starting after / = JPG1717 e. Constant = (2CIFIGLACCOUNTHNT ) 1. For Individual accounts a. Chart of accounts = T2A/ b. Account id = 6171700001" - Sorry, but ABSOLUTELY not clear!
"/" is not allowed inside a variable in URL. Try to escape with %2F
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
16 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.