SAP Analytics Cloud - Link Dimension

[#1]

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.