cancel
Showing results for 
Search instead for 
Did you mean: 

Filter Dimension Members based on Property of Another Dimension

kvsreekar
Participant
0 Kudos
873

Hi,

I'm working on a Planning Model where I would like to filter certain dimension members based on the Property value of another dimension.

In the below example (screenshot) I have two dimensions: PROJECT & SECTION.

SECTION dimension value is maintained as a Property on the PROJECT dimension.

So, when I display both PROJECT & SECTION dimensions in a planning story for user input, I only want the right Combination of dimension members displayed so that the user accidentally doesn't input measure values against the wrong combo.

This is a very common & basic requirement for planning solutions. I'm sure there should be some smart way to achieve this.

Another work around I can think of is to populate transactional data flags (value 1 for example) for the desired combo using a Data Action on a different measure and hide that measure in the story and do Supress zero and blank rows. But that's not a smart solution.

Accepted Solutions (1)

Accepted Solutions (1)

N1kh1l
Active Contributor

kvsreekar

The transaction data flag though not so smart has been commonly used to achieve this requirement. The native BPC dimension override functionality is still not available in SAC. There have been variations of this technique used but at the heart of all those lies the transaction data flag which is what creates the combination tags of valid combination. You can see some approaches discussed below.

https://blogs.sap.com/2023/10/23/sap-analytics-cloud-dynamic-account-filtering-based-on-a-data-mappi...

https://blogs.sap.com/2023/04/03/sap-analytics-cloud-hiding-invalid-data-combination/

Br.

Nikhil

kvsreekar
Participant
0 Kudos

Thanks nikhil_1486

Answers (0)