SAP Analytics Cloud - Link Dimension

[rachugh]

Hi,

I am looking to setup a story which shows WBS lines that is connected with Profit Center. There are 2 dimensions PC & WBS , how should I setup this story?

[N1kh1l]

rachugh

This feature has been requested under the influence program. You can vote for it.

Improvement Request Details - Customer Influence (sap.com)

Till it gets delivered

2 ways to achieve valid combinations

• Setting up validations at Model level. This will ensure data posting to valid combination but will still show all combinations in stories. help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/e275adffd7f14151a97721d83f4a8...
• seed valid combination using Advanced formula (preferred). This will ensure only valid combination show up in stories. You can combine this in addition to the validation above.

For option 2,the way you can achieve this currently is by transaction data tagging. Using the attributes of your WBSELEMENT dimension post dummy transaction data of 1 (like a flag) at valid combination of wbs element, profit center using the Advanced Formula Data Action. This will be like seeding the valid combination at start of planning cycle. When you create stories, suppress on null and 0's and the resulting layout will be a valid combination of what you expected.

Sample Advanced Formula can be as below. Adjust as per your Model and Dimensions.

MEMBERSET [d/Measures]=AMOUNT // Change as per your Measure
MEMBERSET [d/ACCOUNT]="SEED"  // Change as per your Account member


DATA([d/profitCenter] = [d/wbselement].[p/profitcenter]) = 1

Hope this helps !!

Please upvote/accept if this helps !!

Nikhil

[rachugh]

My requirement is to put filter on Profit Center as complete hierarchy. I cannot put filter on the attributes of the dimension as it will just the list of members what I need is the Profit Center hierarchy and from then WBS elements should be derived automatically.

[rachugh]

We have around 100k lines of WBS and what we did was combined Profit Center & WBS in 1 dimension so that we can get the PC hierarchy. User wants to select the PC as per the hierarchy and then all WBS related to that PC node should appear in the table. Is this possible?