07-02-2024 05:20 AM
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 ?
07-02-2024 05:28 AM
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
07-02-2024 05:31 AM - edited 07-02-2024 05:32 AM
Already used as True. its 3 lakh+ cell are there, where there are data present, and i have to add all those data
07-02-2024 05:41 AM
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.