cancel
Showing results for 
Search instead for 
Did you mean: 

Master data reporting in SAP BW

Former Member
0 Kudos

Hi everybody,

we are using BW for reporting on master data. The concerned objects are all customer developments. We are experiencing problems concerning design questions and the print layout of the queries:

Our consultant advised us to use info objects for the implementation of master data in BW and to build the info objects just as the datasources in the source system, meaning: 1 table in the source system = 1 info object in BW. What are your experiences on that?

Second issue is, we have several long text informations. With the limitation of infoobjects to max. 60 digits, we are forced to split the contents into several infoobjects.

How do you handle long text informations in BW? (We need a printable report.)

Thank you for your suggestions, kind regards, Kathrin!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kathrin,

It's OK to build one datasource on one table in the source system and load it into one infoobject. The main thing here that if you need to link these IOs that you load appropriate attributes into IOs to be linked.

Not knowing details it's hard to tell if this approach is the best.

About 60 symbols limitations you can see these refs:

Best regards,

Eugene

Answers (2)

Answers (2)

Former Member
0 Kudos

What would be the data flow model look like when we load Master Data into an InfoObject?

Former Member
0 Kudos

Hi Kathrin,

First of all are you using infoobjects as infoproviders for your master data reporting? Is that what you meant?

On the text issue, this problem has come up a number of times in projects I have worked on. Solutions include using documents to hold this information, or like you said creating multiple objects and then writing a query where they sit side by side. Another way may be to use the Web Application Designer to create them in tables to make the view seamless that they are different infoobjects. We are about to embark on a POC at a client so we are planning to see if we can do something clever with free text in the Web Application Designer using current toolset and some HTML or Javascript.

Hope some of this helps.

Ian