Question:
I want to create a query which contains values that are not in the InfoCube, but are in customising in R/3.
For example, I want a matrix query that displays the number of order lines for a material group and customer group combination using restricted key figures:
Mat Grp 00001 00002 00003
Cust Grp
00001 1 1
00002 1
00003 3
When you write the query the only values available for material group and customer group will be those that have data in the InfoCube. My problem is that I want to display the material group/customer group values from R/3 even if there have not been any order lines yet.
I don't want to use the InfoObject in the rows and columns as I always want the query to have the same format.
Any ideas?
Answer:
there is 2 ways to do this.
1) the old way is with an infoset joining the characteristic of interest and an ODS (simple to understand, but slow).
2) the other way is described in the documents "OLAP business scenarios" from tech-ed '03 and in "Selected OLAP Features" in the BW Media Library (Presentations SAP BI/SAP BW) under the BW part of the SAP Service Market Place.
it involves creating a multiprovider between your data cube and the characteristic of interest. adding the SAP generated keyfigure (1ROWCOUNT) to your query restricting it to the characteristic infoprovider, then setting the restriction as a constant selection, then setting "display values not posted."
this method is faster because it creates only enough of the outer join to display the characteristics not in the cube, and then you get the multi-dimensional analysis speed of the cube.
_________________
when in danger or in doubt, run in circles, scream and shout.
Answer:
Thanks. I have downloaded the documents.