Skip to Content
0
Former Member
Sep 28, 2005 at 08:55 PM

Non-cumulatives and MultiProviders

60 Views

Hi,

I posted a message some days ago about this topic, but didn't get any feedback, so I will try again. Since I belive that this topic must be important to others as well. I can imagine many situations where non-cumulative cubes are useful, and of course also many situations when these cubes need to be combined into a MultiProvider.

The confusing thing here is the SAP documentation (BW 3.5): http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm.

It says that "You should not use more than one non-cumulative InfoCube (InfoCube with at least one non-cumulative key figure) because this could lead to incorrect query results.".

However, and this is interesting, there's alot of documentation on this before 3.5 that says that it works perfectly ok to include several n.cum cubes in one multiprovider. See for example the 3.3 help (http://help.sap.com/saphelp_bw33/helpdata/en/ad/6b023b6069d22ee10000000a11402f/frameset.htm): "Several non-cumulative InfoCubes can also be grouped into a MultiProvider. These non-cumulative InfoCubes can contain different time characteristics.". This is completely contradicting the statement in the 3.5 documentation. Is this some feature that has changed?

IF it is the case that it isn't recommended to do so I'm still looking for solutions and workarounds, and in which specific cases (if any) is it safe to combine n.cum cubes in multiproviders?

Many thanks, and yes - I will assign points to any helpful answers 😊

David