on 08-18-2015 6:31 AM
Hi Expert,
In my current project requirement we are trying to load text description from BW infoobject to BPC dimension properties but I thing properties only can support loading attributes, not text in BPC dimension properties.Currently we are loading both text and attributes in BW from ECC. We are using standard info object in BW is 0HRPOSITION for loading the both text and attributes from ECC.This standard infoobject also use as an attributes in other infoobject .My question is that is there any way can load only text from 0HRPOSITION infoobject to BPC dimension properties by using standard DM package and transformation file.
Regards
Khokan
Hi Khokan
If you do not wish to implement Start/End Routine BADI, here is one more way that you can try but it totally depends on the kind of data you have.
I believe that 0HRPOSITION is a kind of master data that might not change quite often. If it is true, then you can maintain a conversion file where External column will be filled with ID and Internal with the description.
You can map ID in the transformation and call this conversion for your attribute so that only text gets loaded.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gajen and Andy
Thanks for your reply I just tested it by mapping id in the transformation and conversion and it works fine.Now I have one question, in future if there is some new join or employee position changes then how it map in BPC? is there any automatic process or manually mapping in BPC?
Khokan
Hi Khokan
If you are going to use this approach, you will have to update conversion file manually for future changes. The basic premise is that this master data is not going to change much-maybe once a year. But if you suspect that the changes are going to be frequent, it is better to use BADI.
Hi Khokan,
You need start/end routine in your transformation file to load text into a property.
You need someone knows ABAP to help you with that BADI.
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
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.