MultiProvider/CompositeProvider scenario in Datasphere

[Mandar_Damle]

Hello Expert,

In BW, we have a multi-provider/composite provider concept where union operation is performed. Here, we can assign individual characteristics and key figures from a particular or multiple aDSOs (cubes/DSOs).

Also, MD dimensions' tables automatically get associated with TD facts' table (Thanks to the SID concept). Then the dimensions with their attributes and texts can be used in BW queries.

What is a similar artifact in Datasphere that behaves like a MultiProvider/Composite provider?

Also, like BW, is the dimension and fact association done automatically in Datasphere as well? If not, what is the parallel for it in Datasphere?

Thanks!

Regards,

Mandar Damle

[MKreitlein · Accepted solution]

Hello Mandar_Damle,

the counterpart in SAP Datasphere for a Multiprovider/Composite is a so called FACT View.

It is a graphical or SQL view containing one or more unions. See an example:

On the left you can have different other fact views (views which simulate your previous cubes - they read data from an underlying local table or another view).

On the right side you have your output structure (the final fact view), where you do an association of master data attributes or text. This is a manual task, for each and every record field, where you want to have attributes or texts in your reports.

The problem is, you cannot have more than two views in one union, so you need as many as you have source views. And the automatic assignment works only if your technical names (I guess) in the underlying tables or views are identically. Otherwise it is a manual mapping.

If you don't have all fields in all source providers, you can generate new blank columns with the F(X) Symbol (see above).

This final view is the basis to build an Analytic model on top, which reflects the former Query.

In SAC, you don't replicate the Fact view anymore, like you did with the BW Query, but you build a story directly on top of the Analytic Model. There is no additional object in SAC from Datasphere, only your SAC story.

Hope this helps,

Martin

[Mandar_Damle · Accepted solution]

Thanks for your detailed response with pictorial representation, Martin! I really appreciate your help! So, my takeaway is - Use view for achieving the MP/CP functionality and associate all dimensions with texts manually with final FACT view.

[Joel_B · Accepted solution]

Great response as always! Just one correction, a union can have more than 2 views, but the tool makes it seem there is a 2 union limit. To add more than 2 views to a union, drag a new source over the union icon. The right fly-out menu will appear, but don't click anything. Instead, hit the escape key. If all goes well, you should have 3 or more items in the union. We have unioned up to 6 sources this way.