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?

[Subhasmit]

In SAP Analytics Cloud, you can create links between dimensions in multiple models. You can link dimensions between models to create charts or tables that display data from multiple models.

Linked dimensions also let you create filters that simultaneously update all charts that include linked data. Filters on linked dimensions can be used at the story, page, and linked analysis level.

Note-

• he attributes of a dimension must match the attributes of the dimension it is linked to:

  • Description to Description
  • ID to ID

  If the attributes don't match, information might not be returned when a filter is created, and a “(No Value)” flag will appear for an unmatched dimension member.

• Chart filters don't affect linked dimensions, because they're applied to a single chart.
• Some dimension links may not apply filters to all charts. This happens when filters applied to one model can't be translated to meaningful filters on a second model.
• For BW remote models, consider that the Description might be language-dependent.
• Sorting doesn't work with linked dimensions

How to Create Linked Dimension-

1. Use one of the following methods to open the Linked Dimensions dialog:

   • Select (Link Dimensions) from the menu bar.

   • 1. • 1. Select a chart or table.
          2. In the Builder tab, in the Data Source area, select Add Linked ModelsCreate Model Link.

     2. Select a model from the list of models included in your story, or in the drop-list select Add Model to search through the models you have access to.

     3. (Optional) To change how the dimensions are displayed in the Select a model area, select Data Samples and then select an attribute:

     • Description
     • ID
     • ID and Description
   • Choose one or more dimensions.
   • Choose a second model and select one or more dimensions.
   • (Optional) In the Matched Dimensions area, select a dimension, select (Link Attribute) and then choose from the linking options.By default, the Description attribute is used to match members between the linked dimensions. However, for non-hierarchical dimensions it is possible to change the attribute that is used for linking.

   • Select Set.

   • Review the links and if necessary, edit them or select Add Model Link to add more links.

   • When finished, select Done.

[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?

[Subhasmit]

From the data modelling( wrangling) you can combine two fields as per your needs.

I think this answer will helpful for you.

[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?

[PRAT280]

Hi,

Can you please check this blog and check if it make sense to follow the guidance

Dimension Combination Rule in SAC | SAP Blogs

Hope this is helpful.

[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?