on ‎2021 Oct 25 10:57 AM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 7 | |
| 7 | |
| 6 | |
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.