Forum Discussion

GajendraS's avatar
GajendraS
New Contributor
2 years 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 add...
Cube View
Parameters
FredLucas's avatar
FredLucas
Contributor III
2 years ago

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
2 years ago

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
    2 years ago

    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.