Blending for SAP BW Live Data Models

[SANA11]

Hi all, 

My objective is to blend models using a live data connection from BW4HANA to create a consolidated table that includes both actual and budget data. I have two queries from the BW system: one for actual data and another for budget data. Using the live data connection, I extracted the data and saved these models in SAC. The volume of data is not large enough to trigger the limit exceed restriction. However, when attempting to blend the data whether using the optimized design or the classic design the data does not blend successfully, and the following warnings are displayed.

What do these warnings indicate? Specifically, the first warning is problematic since I need to create financial statements. How can we successfully perform data blending in this scenario? please be specific avoid sharing generalized solutions 

Warning: Blending is not supported between the linked models. This link can only be used for filtering. 

Warning : You can blend these models as long as the amount of data returned from the systems not performing the blend is within each system's defined limit

[Ivan_C]

Hi, you might find your answer on this page:

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/7b9defa34dc34c0881dee...

If you are trying to create financial statements you likely want to blend data in a table. This is not currently supported in the Optimised Story Experience. This might mean all the other blending limitations are secondary.

From our experience with blending in SAC, it is pretty terrible at best, and I would strongly suggest you perform the required data joins in the data model in BW, and not try to achieve it in SAC. A Composite Provider in BW across your Budget and Actual data would definitely be the preferred approach.

Cheers, Ivan.