on 2023 Nov 28 10:52 PM
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.
Request clarification before answering.
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/04/03/sap-analytics-cloud-hiding-invalid-data-combination/
Br.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
56 | |
10 | |
8 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.