Combine two DSO for reporting

[oliver_uy2]

Hi guys:

Our client wants a monitoring report where it will display PRs and its corresponding POs if it is available or not and would display all the GR/IR values based on PO (1 PR data would have multiple PO data, and one PO data would have multiple GR/IR data) Is there a way where we can combine the DSOs and would do a logic where it would display all PRs with or without POs and POs with or without GR/IR in the query? we have 1 DSO for PR, another for PO, and another for GR/IR.

Thanks,

[Former Member]

Hi Oliver ,

I think best way to do this is create a cube on top of DSO having PR data .

Do lookup on other DSO (having POs) at routine level and with respect to each PR read corresponding POs and GR/IR values and create records in your package i.e. read all POs ,GR/IR corresponding to one PR and append them in package .

In this way your cube have consolidated data and you can build a multiprovider on top of it which can be used for reporting .

Regards,

Jaya Tiwari

[former_member188080]

Hi,

You can have multiple options

1. You can have Multiprovider or Infoset for this

2. You can have Infocube on top of DSOs. You can put the logic there while populating the Infocube data.You can have Multiprovider on the top of that cube. And you can have report on Cube or Multiprovider...

Thanks and regards

Kiran

[oliver_uy2]

Thanks Guys.

The problem with multiprovider is that when i create bex report and filter PR it would generate multiple entries in the query (one would be from PR DSO, another would be from PO DSO, and GR/IR DSO). Is constant selection still advisable in generation of report? i read an article informing that it is not good to use constant selection in the report.

With infoset, the problem would be if the PR would not have PO Data it should still be displayed in the query. is there a way where we can do a left outer join from PR to PO then another left outer join from PO to GR/IR?

Thanks,

[anindya_bose]

Hello Oliver

as such I do not see any problem with constant selection BUT just check if query based on MultiProvider consists of DSOs works well for constant selection . Did not remember the exact problem but there were some problems with DSO.

In that case you need to push data to cubes and build a MP on top of those two cube. Here constant selection should work properly.

Else, go for InfoSet.

Regards

Anindya

[Former Member]

Hi,

The Multiprovider option with Constant selection should be the good choice till you are getting the report output in required time.

You can even think of the option suggested by Jaya, but in that case you will have to create one more data flow which will increase your maintainance overhead but this might improve your reporting performance.

Regards,

Durgesh.

[oliver_uy2]

Can constant selection still be fine if we have 3 or more Cubes in one multiprovider?

Thanks,

[Former Member]

Hi,

I am not sure, but you can check below links.

[;

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70dcd7b5-6a3d-2d10-c984-e835e37071a2?QuickLink=index&overridelayout=true]

Regards,

Durgesh.

[oliver_uy2]

Thank you will check on it if it will be applicable in our report.

[Former Member]

Hi,

We have two options 1. Multiprovider 2. Infoset.

Multiprovider: You can create multiprovider it will give you two DSO data.

Infoset: You can combined your two dso it will give you the data based joins.

hope it hleps you.

Regards,

Venkat.

[former_member182343]

Better to use Multirovider and use Constant Selaction functionality to get infoset functionality.

[ravi_chandra3]

HI

Create the mulitprovider on the top of the DSO and then create the report on the multiprovider.

Thanx & Regards,

RaviChandra

[ravikanth_indurthi]

Hi,

Have you tried creating multiprovider or Infoset for the given combination...

Hope this helps...

Rgs,

Ravikanth.