You create a DataStore object (advanced) using the "Data Mart DataStore Object" modeling property. Which behaviors are specific to this modeling property?
2 correct answers
What is the maximum number of characteristics that can be used for a multi-dimensional exception aggregation in a BW query?
You use a measure with semantic type "Amount with Currency Code" in your SAP HANA calculation view. Which kind of currency reference can be assigned to the measure?
You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time update scenario. Which fields are added to the DataSource automatically?
3 correct answers
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?
Where can you automatically generate a process chain?
Which objects can be affected by the key date in a BW query?
Which features can be leveraged using a CompositeProvider in SAP BW/4HANA? Note: There are 3 correct answers to this question.
What are some of the variable types in a BW query that can use the processing type SAP HANA Exit?
What are the possible ways to fill a pre-calculated value set (bucket)?
Using SAP HANA as modeling focus, you want to combine data from different sources. Which techniques can you use?
In a DataStore object (advanced) of type Data Mart, which request-based deletion is possible?
You want to build Web-based dashboards with interactive visualizations. Which SAP tool would you use?
From which SAP BW/4HANA objects can you start generating an external View?
You want to define a restricted column in an SAP HANA calculation view. What do you need to define?
Which features are related to the start process in a process chain?
You created a generic DataSource in SAP ERP using a function module. Which manual activity could you perform to enable your generic DataSource to use as an ODP_SAP DataSource in SAP BW/4HANA?
You create a report with SAP Crystal Reports for Enterprise and need an analysis view as a data source. Which tool can you use to create this analysis view?
You want to build an SAP HANA calculation view of data category CUBE, but you get the "no measure defined" error. For the business requirement, a measure does not make sense. Besides changing the data category to DIMENSION, what do you have to do?
You want to add a Source System of type Big Data in SAP BW/4HANA. Which adapters can you use to reference the remote source system?
In an SAP HANA smart data integration flowgraph, which transformation options are available?
What is the purpose of an architecture overview model?
Which development object needs to be built to generate an HDI Container?
Which join types can you use in a CompositeProvider?
Which features of an SAP BW/4HANA InfoObject are intended to reduce the physical data volume?
You are involved in an SAP BW/4HANA project focusing on General Ledger reporting and want to use the SAP ERP Standard DataSource 0FI_GL_14 (New GL Items). Which transactions can be used to activate this DataSource?
In which ODP context is the operational delta queue (ODQ) managed by the target system?
SAP provides three data warehousing solutions to provide customers more flexibility. How is SAP Data Warehouse Cloud positioned?
Which of the following are possible source types for an Open ODS view?
You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder?
You would like to highlight the deviation from predefined threshold values for key figure actual revenue. Which BW feature do you use?
What are benefits of separating master data from transactional data in SAP BW/4HANA?
What are some of the advantages of using SAP BW/4HANA business content?
Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP)?
Which features can be leveraged using a CompositeProvider in SAP BW/4HANA?
Which layers offer the virtualization approach for the layered scalable architecture (LSA++) of SAP BW/4HANA?
What kind of cold data tiering options do you have with SAP BW/4HANA?
Which external hierarchy properties can be changed in the query definition?
You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? Note:
Which data deletion options are offered for a standard DataStore object (advanced)?
Which interface do you use to create a BW InfoObject with access type "SAP HANA view"?
The Database Explorer in the Web IDE for SAP HANA provides a data file import wizard to create a table in SAP HANA from a flat file. What are possible actions after the system suggests the target structure?
What are benefits of using an InfoSource in a data flow?
Which features does SAP Analysis for Microsoft Office provide?
What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?
What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA?
You create a transformation from a DataSource to a DataStore object (advanced). The DataSource provides an additive-image delta for data. Which key figure aggregation type do you select?
With SAP BW/4HANA 2.0, SAP introduced a new capability called Write Interface for DataStore objects (advanced). Which SAP solutions can leverage this interface to push data into the inbound table of DataStore objects (advanced)?
In a BW query with cells, you need to overwrite the initial definition of a cell. With which cell types can this be achieved?
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 settings before you can successfully build the HDB module?
You created an Open ODS view based on a database table in SAP HANA to virtually display the data in SAP BW/4HANA. Real-time reporting requirements have now changed and you are asked to persist the data in SAP BW/4HANA. Which objects will be created when using the Generate Dataflow function via the Open ODS view?
With which query considerations can you optimize the query performance? Note: There are 3 correct answers to this question.
You use SAP HANA to integrate an HDI Calculation View (data category Dimension) into another HDI Calculation View (data category Cube with Star Join). What do you need to do before you can integrate the HDI Calculation View (data category Dimension)?
Which tasks are part of the Business Blueprint and Data Model Definition phase in an SAP BW/4HANA project? Note: There are
For which requirements do you suggest an SAP HANA modeling focus rather than an SAP BW/4HANA modeling focus? Note:
Which source types are available to create a generic DataSource in SAP ERP?
Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?
With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework. Which technical namespace is assigned to identify the new SAP ERP-related business content?
What are the key benefits of using the SAP Landscape Transformation Replication Server for data provisioning into SAP HANA?
To achieve an urgent business requirement, you choose the field-based modeling approach, but you also want to leverage a characteristic hierarchy. On which level does LSA++ architecture recommend the appropriate InfoObject to be associated?
What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context?
In an SAP HANA Calculation View, you need to combine attributes data (left table) and the data’s language-dependent texts (right table) using a text join. What should you select to restrict the result set to the logon language?
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?
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?
What are the reasons for implementing CompositeProviders?
Which of the following are possible delta-specific fields for a generic DataSource in SAP ERP?
How can the delta merge process be initiated?
You are following a top-down method for your SAP BW/4HANA modeling project. What would be your first task?
You expect to have more than 2 billion records as master data references for a characteristic in your data model and want to use the high cardinality option. What do you need to consider in reporting?
What can you leverage using the live data connections of SAP Analytics Cloud with SAP BW/4HANA?
You have created a custom characteristic with the technical name "COSTOBJ". Depending on the controlling area, you need to have different attribute values assigned. How do you design the model? MF
You want to turn a display attribute into a navigation attribute, but it's not possible to do it in the SAP BW/4HANA system. Which setting of this display attribute could be the reason? Note:
Why should you run an SAP HANA delta merge?
With SAP HANA 2.x, you can model Calculation Views in the SAP Web IDE for SAP HANA. Which node types for a native SAP HANA Calculation View are available in the SAP Web IDE, and not available in SAP HANA studio?
You want to combine an existing SAP BW/4HANA Data Model with virtual data from a new non- SAP source system for test purposes. Which approach should you consider for rapid prototyping?
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?
When loading master data for a material, you want to look at the new values before they are released for reporting. What could you do using modeling features?
Your company is using SAP S/4HANA as a business operational system and you have to provide operational analytical reports. Why might you consider SAP S/4HANA embedded analytics?
You have created an SAP HANA Calculation View in SAP Web IDE for SAP HANA and want to integrate it into an SAP BW/4HANA CompositeProvider. Which "Settings for HANA Consumption in BW" in transaction SPRO can you use in this scenario?
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 0CALMONTH. Which processing type do you use?
Last changed10 months ago