· 

BW/4HANA Query Link Components

In BW/4HANA SAP offers you the possiblity to link restricted or calculated keyfigures accross different Composite Providers. The advantage of the link components concept is that they can automatically synchronized whenever you make changes in the source or master component. If you are not familiar with this concept.

 

SAP Help:

"A linked component can be automatically synchronized whenever changes are made to the corresponding source component.

Example scenario: You have two highly similar InfoProviders, IP_A and IP_B. You have created the query Q_A for IP_A. You now want to create the query Q_B for InfoProvider IP_B. You want this query to be very similar to query Q_A and to be automatically adjusted whenever changes are made to query Q_A.

To do this, you use the link component concept: You create the linked target query Q_B for source query Q_A. This is more than just a copy, as the system also retains the mapping information. This mapping information makes it possible to synchronize the queries."

So the concept is really nice because you can ensure that your keyfigures with the same name has also the same configuration, e.g. your turnover is configured correctly on any Composite Provider in your system. Now lets create a new link component. First we select a restricted keyfigure on our Composite Provider and goto "Linked Component" view in Eclipse.

New Keyfigure in Eclipse
New Keyfigure in Eclipse

Use the right click on the keyfigure in the "Linked Component" view and select "New Component"

New Query Link Component
New Query Link Component

A new dialog appears, which allows us to create a new linked keyfigure. First we have to define a Target Name and a Target InfoProvider. Now we can click on Create Proposal.

Create new Query Link Component
Create new Query Link Component

After the status is green, we can create this new link component.

Keyfigure with Link Component
Keyfigure with Link Component

So now let's come to an issue what happen when you unlink your query components by mistake. Here the trouble begins. There is no function to link your broken query link component again to the original target. Which means you have to create a new link component and replace it in all your queries but for this I create a little tool called Query Link Component to link the components again.

 

Query Link Component Tool
Query Link Component Tool

So let's make an example, we just decouple our created link component and link it afterwards again.

Decouple an existing link component
Decouple an existing link component
Keyfigure without Link Component
Keyfigure without Link Component

Now we open the Query Link Component program and fill out all neccessary information and link our keyfigure again.

Create the Link Component again
Create the Link Component again

Click on Execute (F8)

Linking was successful
Linking was successful

Now we close and reopen the keyfigure in Eclipse and we will see the link component is back again.

Query Link Component works again
Query Link Component works again

Conclusion

I like the concept of linked components in BW/4HANA but I don't know why SAP has no such function to link a broken query component again. My little tool helps me to fix this issue and save me a lot of time. Do you use the Link Components Concept in your BW/4HANA?

author.


Hi,

I am Tobias, I write this blog since 2014, you can find me on twitter, facebook and youtube. I work as a Senior Business Warehouse Consultant. In 2016 I wrote the first edition of Analysis Office - The Comprehensive Guide. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.


Subscribe


  • In my newsletter you get informed about new topics
  • You learn how to use Analysis Office
  • You get tips and tricks about SAP BI topics
  • You get the first 3 chapters of my ebook Analysis Office - The Comprehensive Guide for free
* indicates required

You want to know SAP Analysis Office in a perfect detail?
You want to know how to build an Excel Dashboard with your Query in Analysis Office? 
You want to know how functions in SAP Analysis Office works?

 

Then you have to take a look into Analysis Office  - The Comprehensive Guide. Either as a video course or as a ebook.


Write a comment

Comments: 0