Skip to Content
avatar image
Former Member

Load BW Text data to BPC Dimension Properties

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 19, 2015 at 03:13 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Gajendra Moond

      Hi Gajen and Andy,

      There is no need to create another text infoobject in BW.We pull the data through conversion file and it's working fine.

      Thanks Gajen and Andy.

      Khokan

  • avatar image
    Former Member
    Aug 18, 2015 at 06:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Khokan,


      Alternative would be create an attribute for that infoobject in BW with description as its value, so you either do it in BW or during loading.


      or upload it via text file, and map the property of the dimension to the description column.


      Andy