To apply sparse row suppression for the huge data

[Ranvir06]

Dear Community,

We have requirement to for reporting in which when we run the report its huge and we want to reduce the size of data and we want to apply sparse row suppression but since we have used dynamic calc in our column set which is throwing error when we apply sparse row setting. 

Please let me know if you have any idea or solutions which would be very helpful.

Thank You!

[CarlosAlvear]

Hi, 

You have to change a parameter on the column data of that dynamicCalc (see the link below).

"The answer is in the Design & Reference Guide. You can keep the dynamicCalc, you just have to edit a column property so that the column with the dynamicCalc is not considered for the suppression"

Solved: How to bring attribute "Text" fields value into a Cube View without using DynamicCalc - OneS...