Forum Discussion

bjornliow's avatar
bjornliow
New Contributor III
21 hours ago

Reports using Multiple Cubes

Hello,

Would it be possible for me to generate a CubeView using multiple cubes? I know it would be possible using an XFGETCELL since we have to point to the specific cube in the formula.

We are currently utilizing a single cube with all the parent and base level members in our dimensions and are transitioning into 2 Cubes (1 for the summary/parent level and 1 for all base level members). Our existing reports for example A#NET_INCOME.treedescendantsinclusive would work fine in our single cube, but it may not work when we move the parent & base level members to separate cubes.


Cube View
Parameters
Reports

1 Reply

Sort By
  • rhankey's avatar
    rhankey
    Contributor II
    7 hours ago

    What you are describing sounds like vertical extensibility, where the detail cube(s) consolidates into a main summarized cube.  If you have set the Entity dim, and cubes up properly for vertical extensibility where OS out of the box consolidation is summarizing the data to the parent entities in the summary cube, then you simply point the Cube View to the parent cube in the POV, and OS will auto-magically transition from summary cube to detail cubes relative to the entities.

    If you are not using OS's vertical extensibility to link the detail cube(s) to the summary cube, and are using your own logic or some other process to copy summarized data to the summary cube, then no, you cannot have a single Cube View reference multiple cubes.  You will notice you cannot select Cube in the rows or columns, as you can dimensions.  Though could specify a cube override in the row or column expansions, the Cube View is still going to use the dimensionality of the Cube specified in the POV.