Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Modeling Question

Hi Experts,

I have a general modeling question: how can I join data without using an InfoSet?

This is the following case:

DataSource 1:

- Business Partner ID

- Business Partner Function

- Ticket ID

DataSource 2:

- Transport Request ID

- Transport Request System

- Transport Request Client

- Ticket ID

DataSource 3:

- Transport Request ID

- Transported Object Name

- Ticket ID

The final report should give information on

- How many transported objects (counter by Transported Object Name)

- per Transport Request

- per Business Partner (Business Partner ID in a certain Busines Partner Function)

- per Transport Request System/Client

So my problem is: how can I model the subsequent data model? Since the DataSources are that heterogenous a InfoCube will not help as well as several InfoCubes within a MultiProvider does also not fulfill the requirements. As far as I can see the only way would be an InfoSet but this is rather slow.

Any suggestions?

Many thanks in advance!



Not what you were looking for? View more on this topic or Ask a question