Question:
BW Gurus,
We need to create an BW report to shows Qty of material and no. of batches handled every month in different areas. The areas are going to be:
1. Processing
2. Packaging
3. Receiving area.
4. Shipping
The report will have 4 distinct areas mentioned above, will show data per month. The data is coming from 4 different Data Sources from R3 and external systems. Question is:
What is the best way to get the report? One way to have 4 info sources pointing into one cube; another would be to have 4 cubes for each info source and then create a multi provider… Any other better option(s)?
Thanks in advance
_________________
Regards
MA
Answer:
Hi,
You can try infosets for this !!
Regards
Shane
Answer:
Yes, I am using infosets to create Data sources. However my question was abot options.
What is good idea, should I create 4 info sources pointing into one cube; OR 4 cubes for each info source and then create a multi provider…
Regards
MA
_________________
Regards
MA
Answer:
Hii ,
It depends on your req & further process means if you want to go for complex & detailed reporting then multiprovider can be a bad idea regarding some data loading perfomance issues. So according to me you should go for the first option .
Regards
Shane