For a BW query, you want to have the first month of the current quarter as a default value for an input-ready BW variable for the characteristic OCALMONTH.
Which processing type do you use?
- A . Customer Exit
- B . Manual Input with offset value
- C . Replacement Path
- D . Manuel Input with default value
Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question
- A . Use fewer drill-down characteristics in the initial view
- B . Use characteristic filters that overlap
- C . Use exclude functions in the restricted key figures
- D . Use mandatory characteristic value variables
- E . Use include functions in the restricted key figures.
ADE
Explanation:
• 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.
Reference:
• 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/
What are some of the variable types n a BW query that can use the processing tupe SAP HANA Exit. Note: There are 2 correct answers to this question.
- A . Formula
- B . Text
- C . Charateristic value
- D . Hierarchy node
CD
Explanation:
• C. Characteristic value: This type of variable can use the SAP HANA Exit processing type to determine default values for variables using an AMDP class implementation. This can improve the performance and flexibility of queries that are generated as external SAP HANA views12.
• D. Hierarchy node: This type of variable can use the SAP HANA Exit processing type to determine default values for variables using an AMDP class implementation. This can improve the performance and flexibility of queries that are generated as external SAP HANA views12.
Reference:
• 1 https://help.sap.com/docs/r/107a6e8a38b74ede94c833ca3b7b6f51/1.0.8/en-US/b77f3073e9d842d6959e03e74dcefa09.html
• 2 https://blogs.sap.com/2017/09/29/usage-of-sap-hana-exit-variables-for-a-standard-reporting-scenario/
Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question.
- A . Position of child nodes
- B . Expand to level
- C . Time dependency
- D . Sort direction
- E . Allow temporal hierarchy join
In a BW query with cells, you need to overwrite the initial definition of a cell.
With which cell tupes can this be achieved?? Note: There are 2 correct answers to this question.
- A . Selection cell
- B . Reference cell
- C . Formula cell
- D . Help cell
You would like to highlight the deviation from predefined threshold values for key figures actual revenue.
Which BW feature do you use?
- A . Structure
- B . Conditions
- C . Exceptions
- D . Calculated key figures
You want to run a BW query, but you only have partial authorization for the data selection.
What happens related to the BW query in this scenario?
- A . The BW query starts and shows an error message
- B . The BW query does not start running
- C . The BW query starts and the unautohorized values are
- D . The BW query starts and only the authorized data is displayed
You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum)
If you keep the default settings of the BW query, what is presented regarding the result rows?
- A . Only one result row with the sales revenue sum of all 100 customers
- B . Only one result row with the sales revenue sum of the top 10 customers
- C . One result row with the saled revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers
- D . One result row with the saled revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 100 customers
What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct answers to this question.
- A . By using a transformation and data transfer process
- B . By entering the values manually
- C . By referencing a table
- D . By using a query
- E . By accessing an SAP HANA Calculation View of data category Dimension
What is the maximum number of characteristics that can be used for a multi-dimensional exception aggregation in a BW query?
- A . 7
- B . 10
- C . 3
- D . 5
You are involved in an SAP BW/4HANA project focusin on General Ledger reporting and want to use the SAP ERP Estandar DataSource oFI_GL_14 (New GL Items).
Which transactions can be used to activate this DataSource? Note: There are 2 correct answers to this question.
- A . Transaction RSA1 (BI Content) in the SAP BW/4HANA system
- B . Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system
- C . Transaction RS02 (Maintain Generic DataSource) in the SAP source system
- D . Transaction ODQMON (Monitor Delta Queues) in the SAP Source system
What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?
- A . Request is set to failed, error stack is written, and valid records are updated
- B . Request is canceled, records are not tracked, and tarjet is not updated
- C . Request is set to success, error stack is written, and valid records are updated
- D . Request is canceled, firt incorrect record is tracked, and target is not updated.
In which ODP context is the operational delta queue (ODQ) managed by the target system?
- A . ODP_BW
- B . ODP_CDS
- C . ODP_SAP
- D . ODPJHANA
Where can you automatically generate a process chain?
- A . Form a data flow objetc
- B . Within the process chain editor app
- C . from a streaming enable DataSource
- D . Within the process chain maintance
Which source types are available to create a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question.
- A . ABAP class method
- B . Database view
- C . HDI Calculation View
- D . ABAP function module
- E . SAP query
You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into the first persistent data layer in SAP BW/4HANA.
Which options do you have to analyze a potential extractor issue? Note: There are 2 correct answers to this question.
- A . Use the ODQ maintance in SAP BW/4HANA
- B . Use transaction RSA3 (Extractor checker) in SAP ERP
- C . Check entries in table RSDDSTATEXTRACT in SAP ERP
- D . Use program RODPS_REPL_TEST in SAP ERP
What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? Note: There are 2 correct answers to this question.
- A . An ODP source system with contest ODP_CDS must be created in SAP BW/4HANA
- B . The ABAP CDS views must be defined with the appropriate data extraction annotations
- C . THE ABAP CDS views must be released via program RODPS_OS_EXPOSE for BW extraction
- D . An Operational Data Provisioning Framework must be configured in SAP BW/4HANA
You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time udate scenario.
Which fields are added to the DataSource automatically? Note: There are 3 correct answers to this question.
- A . SDI_CHANGE_TIME
- B . SDI_CHANGE_SEQUENCE
- C . SDI_RECORD_MODE
- D . SDI_CHANGE_TYPE
- E . SDI_ENTITY_COUNTER
Which SAP solutions can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (Advanced)? There are 2 correct answers to this question.
- A . SAP Data Services
- B . SAP Landscape Transformation Replication Server
- C . SAP Process Integration
- D . SAP Data Warehouse Cloud.
AB
Explanation:
• A. SAP Data Services: This tool can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (advanced) using RFC or HTTP calls. This can improve the performance and flexibility of data integration scenarios12.
• B. SAP Landscape Transformation Replication Server: This tool can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (advanced) using RFC or HTTP calls. This can improve the performance and flexibility of data replication scenarios13.
Reference:
• 1 https://help.sap.com/docs/r/107a6e8a38b74ede94c833ca3b7b6f51/2.0.6/en-US/8127edbcf2fa488ba04dfc1751d5261d.html
• 2 https://blogs.sap.com/2020/08/17/sap-bw-4hana-write-interface-enabled-adso-connected-to-a-3rd-party-tool/
• 3 https://help.sap.com/docs/r/107a6e8a38b74ede94c833ca3b7b6f51/2.0.4/en-US/8127edbcf2fa488ba04dfc1751d5261d.html
You create a generic DataSource in SAP ERP. "How can you enable your generic DataSource to be used as an ODP_SAP DataSource in SAP BW/4HANA in casa it is not available by default?"
- A . Release the DataSource in SAP BW/4HANA for ODP
- B . Run the program RODPS_OS_EXPOSE in SAP ERP for the DataSource
- C . Generate the PSA table of the DataSource in SAP BW/4HANA
- D . Add a subscription in SAP ERP using the program RODPS_REPL_TEST.
B
Explanation:
• 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.
Reference:
• 1 https://blogs.sap.com/2020/12/25/operational-data-provisioning-simplified/
• 2 https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/c6afacb7077648 85a6fb62f511c24f34.html
You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? Note: There are 2 correct answers to this question.
- A . Analysis
- B . Components
- C . Information
- D . Design Rules
What can you leverage using the live data connectyions of SAP Analytics Cloud with SAP BW/4HANA? Note: There are 2 correct answers to this question.
- A . Existing authorization concepts
- B . BW data models for analysis
- C . BW data models for planning scenarios
- D . Process chain streaming functionally
You create a report with SAP Crystal Reports for Enteprise and need an analysis view as a data source.
Which tool can you use to create this analysis view?
- A . SAP BusinessObjetc Web Intelligence
- B . SAP Lumira, designer edition
- C . SAP Crustal Reportis for Enterprise
- D . SAP Analysis for Microsoft Office
Which features does SAP Analysis for Microsoft Office provide? Note: There are 3 correct answers to this question.
- A . Changing context menu entries
- B . Dragging measures in and out of the report
- C . Displaying data simultaneously in a table and a chart
- D . Including more than one data source
- E . Creating bookmarks for a navigation state
Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?
- A . Search to insight
- B . Smart Discovery
- C . Smart Predict
- D . Forecasting
You want build a web-based dashboard with interactive visualizations using Javascript.
Which SAP tool can you use to create this?
- A . SAP BusinessObjects
- B . Web Intelligence
- C . SAP Analytics Cloud analytics designer
- D . SAP Crystal Reports
- E . SAP Smart Business Cockpits
C
Explanation:
• 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.
Reference:
• 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/
Which node types are only available for graphical modeling of SAP HANA HDI Calculation Views (XS Advanced), but not for SAP HANA Calculation Views (XS Classic)? Note: There are 2 correct answers to this question.
- A . Rank
- B . Intersect
- C . Aggregation
- D . Graph
AD
Explanation:
• A. Rank: This node type is only available for graphical modeling of SAP HANA HDI Calculation Views (XS Advanced), but not for SAP HANA Calculation Views (XS Classic). It allows you to rank the data based on a measure and a ranking rule12.
• D. Graph: This node type is only available for graphical modeling of SAP HANA HDI Calculation Views (XS Advanced), but not for SAP HANA Calculation Views (XS Classic). It allows you to model graph data and perform graph operations such as shortest path, neighborhood search, and pattern matching13.
Reference:
• 1 https://help.sap.com/docs/SAP_HANA_PLATFORM/fc5ace7a367c434190a8047881f92ed8/050f14f7a 6d94d2da905b0a4072ba546.html
• 2 https://help.sap.com/docs/r/e8e6c8142e60469bb401de5fdb6f7c00/2.0.03/en-US/9b9b4b8e0c4d4f0a9c3e7f8a3b5d9b9d.html
• 3 https://help.sap.com/docs/r/e8e6c8142e60469bb401de5fdb6f7c00/2.0.03/en-US/e8b26f49218648eaa8e2ce9b54a8b812.html
You create an SAP HANA HDI Calculation View.
What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correct answers to this question.
- A . Create restricted columns
- B . Provide default time characteristics
- C . Persist transactional data
- D . Combine master data and transactional data
- E . Aggregate measures as a sum
You want to define a restricted column in an SAP HANA calculation view.
What do you need to define? Note: There are 2 correct answers to this question.
- A . A reference to an existing measure
- B . An aggregation method
- C . A condition criterium
- D . An SAP HANA data type
In the Web IDE for SAP HANA workspace, you have imported a project including an HDB module with calculation views.
What do you need to do in the project sittings before you can successfully build the HDB module?
- A . Enter an organization
- B . Reset the project type
- C . Assign a space
- D . Define a package