Forum Discussion

GajendraS's avatar
GajendraS
New Contributor
6 months ago

Parameter not working in Cubeview, once i'm running it for adding 2 flow member data

I have attached the Parameter (Delimited) in the Cubeview. In parameter I have added a drop down what that drop will do it will add 2 flow dimensions members data which is huge. for 2 column data adding it will works fine but when I run it for whole entity.base or account.base, after few minutes OneStream forcibly stop process. how can I solve this problem ?

  • FredLucas's avatar
    FredLucas
    Contributor III

    Hi GajendraS,

    I'd start by ensuring the cube view is set up to allow Sparse Row suppression.

    Do the following checks:

    -  General Settings -> Common -> Allow Sparse Row Suppression = True

    - Under Rows and Columns, select column by column and set both of the following settings to True: Use To Determine Row Suppression; Allow Sparse Row Suppression

     

    • GajendraS's avatar
      GajendraS
      New Contributor

      Already used as True. its 3 lakh+ cell are there, where there are data present, and i have to add all those data

      • FredLucas's avatar
        FredLucas
        Contributor III

        Trying to show 3 hundred thousand cells sound more like a data dump than a report.

        If a data dump is what you are looking for then please consider using data export functionalities such as a Data Management Export Data step.

        However, I'm not sure on what you mean by "I have to add all those data", would be great to understand your use case a little bit better.