What does a Composite Provider allow you to do in SAP BW/4HANA? Note: There are 3 correct Answers to this question.

What does a Composite Provider allow you to do in SAP BW/4HANA? Note: There are 3 correct Answers to this question.

A. Combine Infoprovider using Join and Unions

B. Join two ABAP CDS views

C. Define new restricted key figures

D. Create new calculated fields Integrate

E. SAP HANA HDI calculation views.

Answer: A,C,E

Explanation:

• A. Combine InfoProviders using Join and Unions: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider is an InfoProvider that combines data from several analytic indexes or from other InfoProviders (by union or inner join or left outer join), and makes this data available for reporting and analysis. Storing the data in BW Accelerator or in an SAP HANA database also ensures faster access to data in the query12.

• C. Define new restricted key figures: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider can define new restricted key figures based on the existing key figures of the underlying InfoProviders. Restricted key figures are key figures that are restricted by one or more characteristics13.

• E. Integrate SAP HANA HDI calculation views: This is what a Composite Provider allows

you to do in SAP BW/4HANA. A Composite Provider can integrate SAP HANA HDI

calculation views as part of its data sources, using a virtual table or an external SAP HANA

view. This can enable mixed modeling scenarios that leverage both SAP BW/4HANA and

SAP HANA capabilities14.

References:

https://help.sap.com/doc/saphelp_scm700_ehp02/7.0.2/en-US/63/f3c416bcbf4730bb86e62ef8a54e17/content.htm

https://blogs.sap.com/2018/12/14/implementing-mixed-modeling-in-bw4hana-using-composite-provider/

https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/42/f93a83ae5546d3a7cfd7ff09e25a2b/content.htm

https://help.sap.com/doc/SAP_BW4HANA_CONTENT/06e872f914a44d77b6c692b0273ca 400/20b4b01f5baf46af8fbd439c741adf00.html