8/17/2023 0 Comments Mysql union join exampleThese always reside in different data sources, but they can obviously be brought together over some albeit not all their dimensions. A classic example is to report on Plan and Actuals data at the same time. The advantage of using multi-fact is that it helps us in streamlining reporting KPI from different facts by linking them to the same dimension. In simple terms, here, we will do a union on two datasets having different facts and then associate the union output to the same dimensions. Now if you are not familiar with BW, then don’t panic. The concept is similar to Multi-provider in Business Warehouse. In layman’s terms, the concept of multi-fact is to combine 2 or more facts with the same dimensions for reporting in the data warehouse. Blog Post #10: SAP Datasphere Analytic Model Series Blog 10– Design Multi Fact in Analytic Model (Current Blog).Blog Post #9: SAP Datasphere Analytic Model Series – User Experience and Navigation Paradigm | SAP Blogs.Blog Post #8: SAP Datasphere Analytic Model Series – Data Preview.Blog Post #7: Time Dependency for Dimensions and Texts in Analytic Model.Blog Post #6: Using Variables in Analytic Model.Blog Post #4: SAP Datasphere Analytic Model Series – Calculated and Restricted Measures.Blog Post #3: Motivation & Comparison with the Analytical Dataset.Blog Post #1: Introducing the Analytic Model in SAP Datasphere.This article is part of the blog post series listed below: Currently, multi-fact is supported within fact models in Business Layer in Datasphere and we plan to have the similar functionality available for Analytic models in future as well.įor time being, users waiting for this functionality in Analytic Models, can follow the alternate approach highlighted in this article. This article shows the alternative way of creating and using Multi fact dimensions in Analytic model within Datasphere. The Analytic Model allows for rich analytical modelling in a targeted modelling environment and will be THE go-to analytic consumption entity for SAP Datasphere. The SAP Datasphere Analytic Model Series is intended to provide you with useful guidance on how to utilize the new Analytic Model to leverage the potential of your data landscape.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |