Question:
Hi BW fans
We are having problems producing single line reports with data held at different levels in SAP R/3
We need to report against Sales Order Number from all of the following:
Sales Order Header
Sales Order item
Sales Order Schedule Line
We have successfuly built an infocube containing all the data but cannot create the single line reports our users require.
Has anyone got experience of summary cubes? We have had them suggested but cannot find any guides as to their construction.
Any suggestions would be gratefully received.
Thanks
Jer
Answer:
Summary Cubes? Do you mean MultiCubes (MultiProviders)?
You just created those as ordinary InfoCubes, BUT you need to make the links between the various underlying InfoCubes (this is done via a popup). Mind you that you can only report on characteristics that exist in all underlying InfoCubes (so it's not the same as a database table view).
cheers,
El Belgio
Answer:
Thanks for the reply El Belgio
We are already using Multicubes but they dont solve this problem.
Perhaps a better example:
Need a report with:
Sales Order No. | Cust Ref | Del Date | Turnover Value
as a single line per Sales Order
Cust ref is a header characteristic,
Delivery date is specific to the first sales order item
Turnover value is the sum of the Sales Order item values
Current cube gives 5 rows (if 3 sales order items in place)
Sales Order | Cust Ref | BLANK | BLANK
Sales Order | BLANK | Del date | BLANK
Sales Order | BLANK | BLANK | Turn Val 1
Sales Order | BLANK | BLANK | Turn Val 2
Sales Order | BLANK | BLANK | Turn Val 3
I believe that Data Marts may be another name for what we are looking for but I have no details on what they are and what they do.
Hope this makes sense now.
Thanks
Jer
Answer:
Data Marts are just InfoSources within the BW system itself.
I guess the summary Cube you are talking about is just something you will have to create yourself. In that case you will need to use DataMarts (using your original Cubes as InfoSource via Generate Export Datasource). What you'll need to do is write some update rules that combine various lines into one.
But I can't help you that much further as you will need to figure out your own logic. It's usually not too difficult, but it depends on your requirements. We need something similar, but the "analists" can't seem to find a correct formula to combine such info into one line (it's about forecast in combination with stock). So if they can't come up with a logic they would like to see reported, how can I program it. Anyway, the ball is back in their camp
You might also consider working with ODS objects in stead of InfoCubes as they can be easily accessed (it's like accessing a data dictionnary table in R/3).
cheers,
El Belgio
Answer:
Jer, check wether Cust Ref | Del Date are not part of the sales order schedule line infosource. I don't think so, but if yes, update your cube only with that.
If not, a possible solution :
enhance the structure of the schedule line extractor with field cust ref and field del date,
use the user exit to populate it from header and line item for each schedule line
update the cube only with this schedule line level infosource
the result would then be the one you requested.
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.