What are some of the variable types in a BW query that can use the processing type SAP HANA Exit?
Note: There are 2 correct answers to this question
What are the possible ways to fill a pre-calculated value set (bucket)?
Note: There are 3 correct answers to this question.
Which external hierarchy properties can be changed in the query definition?
Note: There are 3correct answers to this question.
What is the maximum number of reference characteristics that can be used for one key figure with a multi-dimensional exception aggregation in a BW query?
In a BW query with cells you need to overwrite the initial definition of a cell. Which cell types can you
use?
Note: There are 2 correct answers to this question.
You would like to highlight the deviation from predefined threshold values for a key figure visualize it in SAP Analysis for Microsoft Office. Which BW query feature do you use?
You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue.
Using key figure properties in the BW query which two scenarios regarding result presentation can be achieved?
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?
For which scenarios do you use the SAP HANA model focus?
For which reasons should you run an SAP HANA delta merge?
What are the reasons for implementing Composite Providers?
What foundation is necessary to use SAP S/4HANA embedded analytics?
How can the delta merge process be initiated in SAP BW/4HANA? Note: There are 2 correct answers to this question.
Which SAP BW/4HANA objects support the feature of generating an external SAP HANA View?
Which are purposes of the Open Operational Data Store layer in the layered scalable architecture (LSA++) of SAP BW/4HANA?
Which layer of the layered scalable architecture (LSA++) of SAP BW/4HANA is designed as the main storage for harmonized consistent data?
Which development object needs to be built to generate an HDI Container?
Which features of an SAP BW/4HANA InfoObject are intended to reduce physical data storage space?
For which requirements do you suggest an SAP HANA modeling focus rather than an SAP BW/4HANA modeling focus?
In SAP Web IDE for SAP HANA 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?
What are the benefits of separating master data from transactional data in SAP BW/4HANA?
You have an existing field-based data flow that follows the layered scalable architecture (LSA++) concept. To meet a new urgent business requirement for field you want to leverage a hierarchy of an existing characteristic without changing the transformation. How can you achieve this?
What are some of the advantages of using SAP BW/4HANA business content?
Which objects in SAP BW/4HANA allow you to use both fields InfoObjects in their definition?
Which tasks are part of the Business Blueprint phase in an SAP BW/4HANA project?
A. Analyze key performance indicators of the business processes
B. Associate an InfoObject to a field in an Open ODS view
C. Activate SAP business content objects that comply with the layered scalable architecture (LSA++)
architecture
D. Collect central individual information requirements
You need to derive an architecture overview model from a key figure matrix. Which is the first step you need to take?
Where is the button that automatically generates a process chain?
Which request-based deletion is possible in a DataMart DataStore object?
Which source types are available to create a generic DataSource in SAP ERP?
Which SAP solutions can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (advanced)? Note: There are 2 correct answers to this question.
For what reasons is the start process a special type of process in a process chain?
What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context?
A. The ABAP CDS views must be released through the program RODPS_OS_EXPOSE for BW
extraction.
B. The Operational Data Provisioning Framework must be configured in SAP BW/4HANA.
C. An ODP source system with context ODP_CDS must be created in SAP BW/4HANA.
D. The ABAP CDS views must be defined with the appropriate data extraction annotations.
Which of the following are possible delta-specific fields for a generic DataSource in SAP S/4HANA?
The behavior of a modeled dataflow depends on:
• The DataSource with its Delta Management method
• The type of the DataStore object (advanced) used as a target
• The update method of the key figures in the transformation.
Which of the following combinations provides consistent information for the target?
You are involved in an SAP BW/4HANA project focusing on General Ledger reporting want to use the SAP ERP stard DataSource OFI_GL_14 (New GL Items) which is not active in your SAP ERP system. Which transactions can be used to activate this DataSource? Note: There are 2 correct answers to this question.
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?
You created a generic DataSource in SAP ERP but did not release the DataSource for Operational Data Provisioning (ODP). What is the effect in SAP BW/4HANA?
In which ODP context is the operational delta queue (ODQ) managed by the target system?
Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP)?
InfoObject "CITY" is defined as a display attribute for InfoObject "CUSTOMER" InfoObject "COUNTRY" is defined as a display attribute for InfoObject "CITY".In a master data report you want to display the "COUNTRY" of a "CUSTOMER".
Which options do you have to realize this scenario?
Note: There are 3 correct answers to thisquestion.
Why do you set the Read Access Type to "SAP HANA View" in an SAP BW/4HANA InfoObject?
What should you consider when you set the High Cardinality flag for a characteristic? Note: There are
2 correct answers to this question.
For which use case would you need to model a transitive attribute?
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 create a Data Store object (advanced) using the "Data Mart DataStore Object" modeling property.
Which behaviors are specific to this modeling property?
Note: There are 2 correct answers to this
question.
What are the prerequisites for deleting business partner attribute master data in SAP BW/4HANA?
You created an Open ODS view of type Facts.
With which object types can you associate a field in the Characteristics folder?
Which join types can you use in a Composite Provider?
Note: There are 3 correct answers to this
For InfoObject "ADDRESS" the High Cardinality flag has been set. However "ADDRESS" has an attribute "CITY" without the High Cardinality flag. What is the effect on SID values in this scenario?
Which objects values can be affected by the key date in a BW query?
What does a Composite Provider allow you to do in SAP BW/4HANA?
You use InfoObject B as a display attribute for InfoObject A.
Which object properties prevent you from changing InfoObject B into a navigational attribute for InfoObject A?
What are some of the benefits of using an InfoSource in a data flow?
Your company manufactures products with country-specific serial numbers.
For this scenario you have created 3 custom characteristics with the technical names "PRODUCT"
"COUNTRY" "SERIAL_NO".
How do you need to model the characteristic "PRODUCT" to store different attribute values for serial numbers?
You consider using the feature Snapshot Support for a Stard DataStore object. Which data management process may be slower with this feature than without it?
Which feature of a DataStore object (advanced) should be made available to improve the performance for data analysis?
You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP
BW/4HANA. Real-time reporting requirements have now changed you are asked to persist the data
in SAP BW/4HANA.
Which objects are created when using the "Generate Data Flow" function in the Open ODS View editor?
Which recommendations should you follow to optimize BW query performance?
An upper-level CompositeProvider compares current values with historic values based on a union operation. The current values are provided by a DataStore object (advanced) that is updated daily.
Historic values are provided by a lower-level CompositeProvider that combines different open ODS views from DataSources.
What can you do to improve the performance of the BW queries that use the upper-level CompositeProvider?
Which modeling decisions may have side effects on runtime performance?
What are prerequisites for S-API Extractors to load data directly into SAP Datasphere core tenant using delta mode?
Which of the following factors apply to Model Transfer in the context of Semantic Onboarding?
Which type of data builder object can be used to fetch delta data from a remote table located in the
SAP BW bridge space?
What are valid options when using the Data Flow feature of SAP Datasphere?
You have already loaded data from a non-SAP system into SAP Datasphere. You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA.
What do you need to use to combine the data?
Which are use cases for sharing an object?
Which entity can be used as a source of an Analytic Model?
How does SAP position SAP Datasphere in supporting business users?
Which options do you have to combine data from SAP BW bridge a customer space in SAP Datasphere core?
Which source systems are supported in SAP BW bridge?
Which options do you have when using the remote table feature in SAP Datasphere?
Which tasks require access to the BW bridge cockpit?
In SAP BW/4HANA a query has been defined on a Datastore Object (advanced).
Which authorizations does an SAP BW/4HANA user need at minimum to change the query definition?
Where can you assign analysis authorizations?
Where can you use an authorization variable?
A user has the analysis authorization for the Controlling Areas 1000 2000.
In the InfoProvider there are records for Controlling Areas 1000 2000 3000 4000. The user starts a data preview on the InfoProvider.
Which data will be displayed?
Which types of values can be protected by analysis authorizations? Note: There are 2 correct answers
to this question.
How can you protect all InfoProviders against displaying their data?
Why do you use an authorization variable?
While running a query insufficient analysis authorization causes an error message.
Which transaction can be used to trace the missing authorization for the specific characteristic values?
Last changeda day ago