SAP C_BW4H_214 - SAP Certified Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA

•A. Use fewer drill-down characteristics in the initial view: This can improve the query performance by reducing the amount of data that needs to be transferred and displayed at the start of the query execution. The user can drill down to more details later if needed1.

•D. Use mandatory characteristic value variables: This can improve the query performance by restricting the data selection to a smaller set of values that are relevant for the user. The user can also change the variable values later if needed1.

•E. Use include functions in the restricted key figures: This can improve the query performance by avoiding unnecessary calculations and aggregations that are done when using exclude functions. Include functions are also more efficient than selections or restricted key figures when filtering data1.

References:

•2 https://blogs.sap.com/2015/04/20/query-performance-optimisation-tips-in-bw-73/

•1 https://blogs.sap.com/2022/02/02/query-performance-optimization-in-bw-few-tips/

•3 https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2022.12/en-us/0471d0ecea4e4677ba29d9ac1496c24c.html

•4 https://blogs.sap.com/2021/06/02/sap-bw-4hana-performance-optimization-part-i/

•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:

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

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

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

•4 https://help.sap.com/doc/SAP_BW4HANA_CONTENT/06e872f914a44d77b6c692b0273ca400/20b4b01f5baf46af8fbd439c741adf00.html

•Run the program RODPS_OS_EXPOSE in SAP ERP for the Data-Source: This program can enable a generic DataSource in SAP ERP to be used as an ODP_SAP DataSource in SAP BW/4HANA by exposing it to the ODP framework. This allows the data to be transferred via RFC or HTTP calls without using a PSA layer12.

References:

•1 https://blogs.sap.com/2020/12/25/operational-data-provisioning-simplified/

•2 https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/c6afacb707764885a6fb62f511c24f34.html

SAP S/4HANA embedded analytics uses ABAP CDS view based virtual data model to provide real-time access to the transactional data without data replication. It is a collection of SAP Fiori tiles that enable real-time operational reporting. SAP S/4HANA embedded analytics comes with a lot of predefined analytical apps based on Fiori and on SAP Analytics Cloud for various functional areas. The main user types addressed by SAP S/4HANA embedded analytics are business users and analytics specialists.

An architecture overview model is a high-level diagram that shows the main components and data flows of a solution. It helps to identify the required data sources and how they are connected to the target system. An architecture overview model can also show the main business processes and scenarios that are supported by the solution. An architecture overview model is useful for scoping, planning, designing, and communicating a solution.

•SAP Analytics Cloud analytics designer: This tool can help you create web-based dashboards with interactive visualizations using Javascript. You can use the analytics designer to create custom applications that leverage the power of SAP Analytics Cloud models and APIs12.

References:

•1 https://blogs.sap.com/2020/11/05/data-visualization-best-practices-in-dashboard-design-using-sap-analytics-cloud/

•2 https://blogs.sap.com/2021/12/15/sap-analytics-cloud-sac/