MultiProvider vs Report-to-Report Interface
According to the BW development guidelines of my client, query and report should be defined on MultiProvider. At the moment, I have such an architecture for the reporting: one DSO (line item data) --> one InfoCube (selective data for multidimensional analysis) --> one MultiProvider. The scenario will most probably be extended in the near future.
Now I need to report on data from InfoCube (amount, region, date etc.) as well as DSO (single line item data like name, email address etc. for a person). As what I have understood, I have following options to report different set of data from individual InfoProviders:
1. via MultiProvider by restricting the InfoObject 0INFOPROV
2. via RRI (direct jump from query based on InfoCube data to the query based on DSO data)
Is that correct?
Could anyone please recommend an approach for the scenario mentioned above?
Thanks in advance.