Skip to main content
L
LisaC
Newcomer
January 13, 2023

Insert Suppressed Members & Allow Sparse Row Suppression

  • January 13, 2023
  • 2 replies
  • 0 views

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.

LisaC_0-1673622418765.png

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

Thanks in advance!

    2 replies

    C
    ckattookaran
    Newcomer
    January 14, 2023

    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.

      C
      CarlosAlvear
      Contributor
      January 2, 2024

      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

      F
      FlorisvdPoel
      Contributor
      August 6, 2024

      Hi,

      Looking for a solution for this as well.

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

      Thanks!

      Floris

        Terms & ConditionsAccessibility statement