cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Blend data from to models in one story

Josetxu
Advisor
Advisor
1,720

I have a question about the best way to visualize data in SAC stories. We have two models, both have import connection, and have complementary information and I want to generate a story that shows data from both models all together.

In one model I have the P&L data of third parties and in the other model I have the data of the intercompany operations of P&L. We want to visualize all the data together in a single story.

I have tried to link the models in the story, but it gives us some problems, because we see that there are three types of Join (Left, Inner and Outer), but the Outer Join that would allow us to see all the data of both models, cannot be select if we make the link by dimensions with hierarchies (as is the case of the company that we create hierarchies to group the companies according to the process)

Is any workaround to see all the data joined by dimensions with hierarchy

View Entire Topic
pravin_datar
Product and Topic Expert
Product and Topic Expert

You can find two ways of combining data sources here: https://visualbi.com/blogs/sap/sap-analytics-cloud/combining-data-sources-in-sap-analytics-cloud-dat.../

All primary data option will give you a left outer join as illustrated in the above blog.

Thanks and best regards

Pravin

Ukandale
Associate
Associate
0 Likes
The page is giving 404 error