on 07-24-2015 12:00 AM
Hello all
(BPC10.0 SAP NW Version)
I am wondering if it is possible to update the values of the property of a dimension into hierarchy-PARENTH1. We are receiving a flat hierarchy but need to update it in a true hierarchy format in BPC. Because the flat hierarchy follows some rules, I added a property and able to update it exactly like the hierarchy using as many packages as levels.
I am just wondering if in End Routine BADI there is a way to copy all the values from this property to PARENTH1 as we cannot map PARENTH1 in the transformation file for loading attributes.
-
Gajendra
Hi Gajendra,
Yes, it is possible with start/end routine, you can't copy into the hierarchy node, but you can build a hierarchy with the property value.
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gajendra,
In that code it is using account info object, so in your case you need to get the dimension with their properties.
you need to debug to see what is passing through, change
'NODENAME'
'HIER_NAME'
'PARENT'
according to those properties.
and by the looks of it I think that code is not from start/end routine, it is a routine in BW's transformation rules.
Andy
Thank you Andy for your prompt response.
I am debugging by modifying the code and see if I could find any break-through.
I am not an expert in ABAP and am trying to see what can work. The code between TRY and ENDTRY is where I am focused right now. If I happen to resolve, I will update the thread. However, I would appreciate if anyone who has done something similar can share their code or guidance.
Hi Gajendra,
You need to get an ABAPer to help you.
As I've mentioned in my previous post, the code will not work in start/end routine, as that code extract is from a different routine, it might even be a user exit in the BW system.
using that code will not solve your problem.
I'm happy to guide an abaper to solver their problem, but I won't provide code sorry. maybe someone else will.
Andy
Hi Gajendra,
Not sure whether this helps you or not, but you can set up hierarchy without using BADI as well.
Like loading parent nodes as IDs in step 1 (here you may have to allow duplicate records) and then in step 2 loading all masterdata populating PARENTH1 field from the property (Product hierarchy).
This worked for us, but we were loading data from flat files. The only drawback of it is you have to execute two packages or have to create a package link.
Thanks
Best Regards,
Prashant Vankudre
User | Count |
---|---|
6 | |
5 | |
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.