BCS 6.0 Multicube reporting capability
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?