on 05-07-2014 3:07 PM
Hi,
I am using BW 740 SP02 and I need in a transformation rule to use the option "READ MASTER DATA", In fact this enables me to use all attributes of an infoObject and affect them to my data target ( Infocube).
I was wondering if there would be any possibility to affect also master data text of an infoObject and affect them to a data target?
I know that master data text are available through Bex queries, but for my case I need to have them in my Infocube.
Best Regards,
RAFIK
Hi Mohamed,
Using standard rule type this is not possible
However there are two ways to achieve this:
1. you use abap routine to read the text value from text table of info object (BIC/Txxx) in transformation
2. a. add a char info object to your master data
b. create another transformation from text data source to populate this new field (which is actually text)
c. create DTP to populate this new field with text values
d. now you can easily use, 'read master data' rule in transformation and assign the text field to your target field
hope this helps,
Purvang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think its not be possible. we can read master data for attributes not the text.
But you can try to check at dev system by using read master data rule.
if not possible then go with add one info object(at cube level) which can be same length and type of info object.Use field level routine to look up from master data text table.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.