Skip to Content
author's profile photo
Former Member

Non-cumulatives and MultiProviders

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Sep 29, 2005 at 06:51 AM

    Hallo David

    According to the BW definition and my experience, if you use NCUM infoucbe and CM Infocube in Multicube than this affect performance as No Parallel Process will be used by Multiprovider. Even if you have one NCUM Infocube in MP, no parallel processing. Make sure always that you restrict to the Infoprovider/s in the MC otherwise the select will go through all underlying Cubes.

    Regarding data quality, you have to be carefully in combining different cube under multiprovider as in general.

    By the way, if you have to report for example on STOCK, than you need NC KF and you can report on it also on MC.

    Mike

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 02, 2005 at 08:43 PM

    Thanks Mike,

    Anyone else that have some information on this topic? What does SAP have to say? As I mentioned previously in the post, the documentation is almost contradictionary on this matter ...

    Regards,

    David

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 03, 2005 at 04:06 PM

    Anybody else that have some information to share?

    Add comment
    10|10000 characters needed characters exceeded