Skip to main content
M
MJ1705
Newcomer
August 3, 2022
Solved

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

  • August 3, 2022
  • 3 replies
  • 0 views

Hi,

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

MJ1705_0-1659523769340.png

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

MJ1705_1-1659523824130.png

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.



 

Best answer by LeeB

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.

2022-08-03 13_20_03-Using Sparse Filtering in Cube Views.png

3 replies

L
LeeBAnswer
Contributor
August 3, 2022

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.

2022-08-03 13_20_03-Using Sparse Filtering in Cube Views.png

    M
    MJ1705Author
    Newcomer
    August 4, 2022

    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.

    L
    LeeB
    Contributor
    August 4, 2022

    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.

    2022-08-04 09_53_49-OneStream XF.png

     

      Terms & ConditionsAccessibility statement