Forum Discussion

MJ1705's avatar
MJ1705
New Contributor II
3 years ago

Build a cube view with Accounts.base and U1.base

Hi,

I need to build a cube view where I want to have Accounts base as well as U1 Base. Something like this:

The problem is when I am running this - Onestream crashes. Supression settings are on:

Is this because of too many intersections to look at?
Account Dimension has approximately 6000 base members and U1 has 1200.

Can anyone suggest a way on how to build this?
Thanks.



 

Cube View
  • LeeB's avatar
    LeeB
    3 years ago

    Try using Sparse Row Suppression.  Without this OneStream will be evaluating every possible row to determine whether it should be displayed or not.  With Sparse Row Suppression turned on it will perform the data evaluation before generating the rows so you should see a performance improvement.

     

    It's generally a good idea to turn this on when you are building Cube Views which nest Dimensions in the rows.

  • LeeB's avatar
    LeeB
    Contributor II
    3 years ago

    Try using Sparse Row Suppression.  Without this OneStream will be evaluating every possible row to determine whether it should be displayed or not.  With Sparse Row Suppression turned on it will perform the data evaluation before generating the rows so you should see a performance improvement.

     

    It's generally a good idea to turn this on when you are building Cube Views which nest Dimensions in the rows.

  • LeeB's avatar
    LeeB
    Contributor II
    3 years ago

    There is a property to amend on the columns that contain Dynamic Calculations, see below.

    This removes the column from the evaluations that the Sparse Row Suppression functionality performs.

     

  • MJ1705's avatar
    MJ1705
    New Contributor II
    3 years ago

    An additional question to this: 
    What if there is a dynamic calculation running in one of the Columns. Sparse Row Suppression doesn't allow having a dynamic member.