Forum Discussion
Shared Dataset and Composite Dataset
Hi ddfreedie
What I would do is to create a single dataset and host that in an App Workspace just for the dataset. This will allow you to have a single dataset to add KPIs to etc. This will also mean you only have to update a single datset.
To your questions
1. I think soon Composite models will be GA
2. Suggestion above to create a single dataset and then connect reports to this dataset.
3. I would see if there is a way to aggregate any of the SAP data so that is a bit smaller and easier to manage?
Hi
Thanks for your reply.
We have done a couple of projects with that approach. Have DS in one workspace and reports in their own workspace and some reports with excels + shared dataset as composite models.
1. I do not see GA plans for composite model in PBI release plan until sep 2022. So not sure.
2. Yes that has been the idea. To create common dataset and use it as much as possible for all common KPIs. If some additional depertment specific KPIs are needed, to have composite model
3. Unfortunately most of the use cases need transaction data at the detail level. The volume of data is huge. So we plan to create models with transaction + master data (dimensions) and have common/global KPI table/views joined to the model itself. But wondering if anyone has faced similar issue/idea in designing SAP models in PBI.