Skip to Content
avatar image
Former Member

BCS 6.0 Multicube reporting capability

Hi all,

We are currently desiging a SAP SEM BCS 6.0 solution for our client.

We have two consolidation area's and want to make use of the standard SAP Archiving functionality and let the BCS program build automatically the Virtual cube, Reporting Cube and the Multicube.

However as we don't want two different Multicubes as we want to report from both areas, just one with all 4 cubes below(2 reporting cubes and 2 virtual cubes), we tried to align them in the BCS databasis, so we can use the data from the two consolidation areas in one. This seems not possible.

Has anyone had the same situation with another client and can share their experiences?

Thanks,

Pieter

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 10, 2008 at 03:22 PM

    Hi Pieter and welcome to SDN!

    Two ConsAreas from the same data basis will be based on the same multiprovider. And there will be 2 cubes (not four): the totals one and the virtual counterpart (here I'm not talking about the other cubes that might be build upon these two).

    So, what's the problem?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi A Gideonse,

      Yes, we are using the multiprovider scenario, but only half of what you propose;

      1 transactional infoprovider (the BCS data basis)

      1 virtual infoprovider

      1 basic infoprovider (the BCS 'closed periods' cube)

      1 multiprovider

      The closed periods cube (you call it archiving) should be used to store data of prior periods.

      The virtual provider sits on top of the transaction provider

      The multiprovider is where you build your reports, sitting on top of the basic and the virtual inforproviders

      The advantage of this architecture is that only the data that comes from the basic provider via the virtual provider requires any 'on the fly' calculations (the data in the 'closed periods' cube has already been pre-calculated when loaded).

      You can therefore have real-time reporting from BCS, without requiring all report data to be calculated 'on the fly', thereby saving system resources and user time.

      I hope this is of some use, please let me know if you have any further questions.

  • avatar image
    Former Member
    Oct 16, 2008 at 07:32 AM

    Thanks Scotsman, that is helpfull in understanding that this architecture works well for storing the closed periods -> or better requests.

    We have now managed to get two reporting cubes and two virtual cubes in one Multiprovider.

    We build a query in which we can see data from the two consolidation areas.

    I will close this.

    Pieter

    Edited by: A. Gideonse on Oct 28, 2008 7:01 PM

    Edited by: A. Gideonse on Oct 28, 2008 7:22 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2008 at 06:23 PM

    Answered.

    Add comment
    10|10000 characters needed characters exceeded