Forum Discussion

LisaC's avatar
LisaC
New Contributor II
2 years ago

Insert Suppressed Members & Allow Sparse Row Suppression

Hi all, 

We are building cube views which require the expansion of three dimensions in the rows. 

We use the "Allow Insert Suppressed Member" function to insert suppressed members in two dimensions.

Since the expansion would generate a very long list of combinations, we want to use the function "Allow Sparse Row Suppression" to improve the cube view performance.

But when a period doesn't contain any data, the allow sparse row suppression function would suppress all the rows, and we won't be able to insert suppressed members. 

In the cube view rows, we have the suppression setting as in below.

Can anyone give us some advice on how we can tackle this?

Thanks in advance!

Cube View
  • ckattookaran's avatar
    ckattookaran
    VIP
    2 years ago

    A bug in that will not allow parent members to show. Allow insert suppressed members to work only when you have at least one data row. You have got a few options that you can try

    1. Create a form template that can help the user load the data.

    2. You can use a data buffer (you obviously need a source to get the members) and do want OS does for Sparse Row suppression and show the members.

    • CarlosAlvear's avatar
      CarlosAlvear
      Contributor
      12 months ago

      Dear all,

      Do you know whether there are new ways to treat this case? Maybe if there's a way of properly use "Use suppression settings on Parent rows = False"?

      Thank you

  • FlorisvdPoel's avatar
    FlorisvdPoel
    New Contributor III
    5 months ago

    Hi,

    Looking for a solution for this as well.

    Would be great to reopen this topic. Maybe new insights/solutions are developed.

    Thanks!

    Floris