Skip to Content
Former Member
Apr 06, 2011 at 03:13 PM

One report or three reports?


Hi guys,

I have three reports in SAP BW (im using SAP BI 7.0):

1) Credit Management

2) Sales

3) Profit Center

Each report has it´s own view, data source and infocube.

So for example the customer number, company code are the same.

The key figures are the same (like sales or turn over).

In addition to report 1) the 2) sales report has added characteristics like salesorganisation, the 3) has profit center.

No I´m wondering if it is possible to make just one report with all characteristics in one query?

Should I create one DSO with all fields?

Is it possible to create one DSO which has access to each view and assambles the existing fields in one single DSO?

Or would it be to much chaos if there are many characteristics?

Thanks in advance