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

GajendraS
New Contributor

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 ?

3 REPLIES 3

FredLucas
Contributor II

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

 

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

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.