Keep Block for 3 or more dimensions

[Former Member]

Hej Guru,

I was wondering, if there is any way, it is possible to control how the Keep Blocks functionality in Filtering keeps the blocks, when there are 3 or more dimensions in the row or columns?

We have an input form with 3 dimensions in the rows, it could be costcenter, account and auditID. We want the input form to show the combination of costcenter and account, if there is something on one of the 3 auditIDs selected.

However, the Keep Block function only keeps the one outer dimension, if there is data on any combination of the inner two dimensions. So the report will show all combinations of account and auditID, if there is data on one combination for a specific costcenter.

Is it possible to control the Keep Block function, so we can determine the number of dimensions that are kept in the report?

Best regards,

Mikkel

[Former Member]

Do you know, if there is any plan of creating the option?

[former_member186338]

Simply - no idea... There are a lot of things that can be improved in EPM

[Former Member]

This would be a good place to start.

I cannot see the case, where it would make sense business wise that you want to keep the two inner dimensions. The report will quite quickly be very big - at least 4 rows for each kept block, and in my case more than 30

[former_member186338]

Unfortunately - no

Vadim