Skip to Content
Technical Articles
Author's profile photo PALLAB HALDAR

Implementation and discussion on combining of import data ad Live data in SAC.

In this blog I am going to discuss on how we can combining of import data ad Live data in SAC and what are the options are available in SAP Analytics Cloud.

There are two ways to combine data from two source i.e.-

1. At model level by combining option of model data :

Two way we can combine two different dataset.

A. Combining two import data :

  • For Two import connection “Combine Data”  option works perfectly :
  • Steps is given below –
  • While creating  model on purchase data after creating it  use “Combine data” option to add sales order data. Select “Data upload from a file“.


  • Select the sales order excel and combine the data using purchase Order and Sales Order Column



  • Build and save model . Use the model to create a story.


B. For One import connection model  and one Live connection model the combine data :

  • Repeat all the previous steps and create the import model using import data and during creation select the live model connection to collect data from live connection and combine it into the import model.
  • Live connection can be BW or HAN or any other connection.
  • Build and save model . Use the model to create a story.

B. Data blending at story level :

In bend two model ( Import and import) or ( Import or live any combination) and create pages in story after going to data management.


But there is a limitation of this approach. You can add dimension or measure in filter but can not combine two data into single chart. You can create different chart, different filter using different attribute added or blended model and the filter will effect in the chart which build with blended model measure.  Also you can user different model into different chart in a single page.


Hope this will clarify your question.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo P M
      P M

      Once the import data are combined, can it be refreshed with new data that is imported on a schedule?

      Author's profile photo Kris Van Belle
      Kris Van Belle

      Also defining hyperlinks to jump from e.g. an import model based widget to a live model based page or story doesn't seem to be supported. The hyperlink options "Apply selected dimension as filter " and "Apply cascading effect" don't seem to work what's definitely regrettable...