C_BW4H_211

In ADSO of type Data Mart, which request-based deletion is possible?. Any older activated request in the inbound table. The latest not-yet-activated request in the inbound table. The latest request in the change log table. The latest request in the active data table.

What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? 2 answers. An ODP source system with context ODP_CDS must be created in SAP BW/4HANA. The ABAP CDS views must be defined with the appropriate data extraction annotations. The ABAP CDS views must be released via program RODPS_OS_EXPOSE for BW extraction. An ODP Framework must be configured in SAP BW/4HANA.

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?. Using this characteristic as a navigational attribute will impact response time. Using a hierarchy of this characteristic for navigation will impact response time. The local SID values are created automatically during reporting which will impact response time. The high cardinality property needs to be defined in the composite provider.

Which source types are available to create a generic DataSource in SAP ERP? 3 answers. SAP query. Database view. ABAP class method. HDI Calculation View. ABAP function module.

What are the key benefits of using the SAP Landscape Transformation Replication Server for data provisioning into SAP HANA? 2 answers. Virtualization capabilities. Log based replication. Real-time and scheduled data replication. Support of cluster and pool tables.

You want to build an SAP HANA calculation view of data category CUBE, but you get "no measure defined" error. For the business requirement, a measure does not make sense Beside changing the data category to DIMENSION, what do you have to do?. switch from a projection node to an aggregation node. switch from an aggregation node to a projection node. switch from an aggregation node to a star join node. switch from a projection node to a star join node.

What are the reasons for implementing CompositeProviders? 2 answers. To provide an interface for BW queries. to persist combined data for reporting. to provide a virtual data mart layer. to store snapshots for reporting.

You create a adso using the data mart dso modeling property which behaviors are specific to this modeling property? 2 answer. Query results are only shown when data has been activated. Reporting is done based on a union of the inbound and active tables. The change log table will only be filled after data activation. All characteristics are autmatically defined as key.

You would like to highlight the deviation from predefined treshold values for key figure actual revenue which BW feature do you use?. Structure. Exceptions. Calculated key figures. Conditions.

You want to define a restricted column in an SAP HANA calculation view what do you need to define? 2 answers. A reference to an existing measure. An aggregation method. An sap hana data type. A condition criterium.

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?. Enter an organization. Reset the project type. Assign a space. Define a package.

What is the purpose of an architecture overview model?. To identify the required data sources. To identify the user groups and required authorizations. To determine the sequence of projects. To automatically generate the LSA++ architecture.

Where can you automatically generate a process chain?. From a data flow object. From a streaming enabled data source. Within the process chain editor app. Within the process chain maintenance.

Which of the following are possible delta-specific fields for a generic datasource in sap erp? 3 answers (Not sure -Numeric pointer and Calendar day). Time stamp. Record mode. Request id. Numeric pointer. Calendar day.

You are following a top-down method for your sap bw4hana modeling project what would be your first task?. Determine if physical or logical objects will be needed. Determine enhancements of sap business content. Check available sources in the sap erp system. Collect reporting requirements.

With sap bw4hana 2.0 sap introduced a new capability called write interface for adso which sap solutions can leverage this interface to push data into the inbound table of adso 3 answers. Sap data services. Sap landscape transformation replication server. Sap process integration. Sap business technology platform. Sap data warehouse cloud.

Which of the following are possible source types for an open ods view? 3 answers. Database table or view. Adso. Transformation. Compositeprovider. Open hub destination.

You want to run a bw query, but you only have partitial authorization for the data selection. What happens related to the BW query in this scenario?. The bw query does not start running. The bw query starts and shows an error message. The bw query starts and only the authorized data is displayed. The bw query starts and the unauthorized values are 0.

Why should you run an sap hana delta merge? 2 answers. To move the most recent data from disk to memory. To combine the query cache from different executions. To decrease memory consumption. To improve the read performance of infoproviders.

From which sap bw4hana objects can you start generating an external view? 2 answers. Open ods view. Compositeprovider. Semantic group object. BW query.

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?. In the bw composite provider. In the bw infosource. In the bw open ods view. In the bw adso.

You created a generic data source in sap erp using a function module. Which manual activity could you perform to enable your generic datasource to use as an odp_sap data source in sap bw4hana?. Generate the psa table of the datasource in sap bw4hana. Run program roodps_os_expose in sap erp for the datasource. Adapt the function module using transaction ODQMON. Release the datasource in sap bw4hana for odp.

What are benefits of using an infosource in a data flow? 2 answers. Reducing the number of data transfer processes. Connecting sequential transformations in the data flow without storing the data again. Reducing the number of transformations for scenarios with many sources and targets. Storing the extraction delta information of the data source file.

Which features can be leveraged using a composite provider in sap bw4hana? 3 answers. Define new restricted key figures. Create new calculated fields. Join two abap cds views. Combine infoproviders using joins and unions. Integrate sap hana calculation views.

You have created an sap hana calculation view in sap web ide for sap hana and want integrate it into an sap bw4hana composite provider. Which settings for hana consumption in bw in transaction spro can you use in this scenario? 2 answers. External sap hana view. Sap hana repository. HANA deployment infrastructure. Hybrid mode.

What are the possible ways to fill a pre-calculated value set(bucket)? 3 answers. By entering the values manually. By referencing a table. By using a transformation and DTP. By using a query. By accessing an sap hana calculation view of data category dimension.

Sap provides three data warehousing solutions to provide customers more flexibility. How is sap data warehouse cloud positioned?. To empower business users to generate SQL code that is pushed to sap bw4hana. To support business users who want to simplify their own ABAP routines. To support business users with a new self-service tool to model their own dataflows. To empower business users to create and maintain process chains from sap bw4hana dataflows.

What are some of the advantages of using sap bw4hana business content? 2 answers. Automatic content activation during installation of sap bw4hana. Ability to integrate business content objects in custom-defined objects. Accelerated sap bw4hana implementation using ready-made models. Adjustments to activated content objects will be delivered by SAP in a new namespace.

Which modeling function is possible in modeling with an sap hana calculation view that is not possible in modeling with a composite provider?. Create a calculated column. Generate a rank column. Use aggregation for datasets. Combine datasets by union.

Using sap hana as modeling focus, you want to combine data from different sources. Which techniques can you use? 2 answers. Stored procedures. Bapi. Calculation views. AMDP.

Which data deletion options are offered for a standard adso? 3 answers. Deletion of all data from active table only. Selection deletion including data of subsequent targets. Selective deletion of data. Request based data deletion. Deletion of data from all tables.

What is the request handling default setting for error handling in a DTP in sap bw4hana?. Request is set to failed, error stack is written, and valid records are updated. Request is set to success, error stack is written, and valid records are updated. Request is canceled, first incorrect record is tracked, and target is not updated. Request is canceled, records are not tracked, and target is not updated.

Which features of an sap bw4hana infoobject are intended to reduce the physical data volume? 2 answers. Compounding characteristic. Reference characteristic. Enhanced master data update. Transitive attribute.

You define a remote subscription of type upsert in an sap hana sdi real-time update scenario. Which fields are added to the datasource automatically? 3 answers. Sdi_entity_counter. Sdi_change_time. Sdi_change_sequence. Sdi_record_mode. Sdi_change_type.

You want to add a source system of type big data in sap bw4hana. Which adapters can you use to reference the remote source system? 2 answers. SAP hana adapter. spark sql adapter. iq odbc adapter. SAP vora odbc adapter.

What are the prerequisites for deleting master data (for example, cost centers) in sap bw4hana? 2 answers. There must be no bw analysis authorizations defined that use any of the cost centers. There must be no bw query that uses cost center as a free characteristic. There must be no transaction data referring to the cost centers. *Some answer, i don't remember, sorry.

What is the maximum number of characteristics that can be used for a multi-dimensional exception aggregation in a bw query?. 3. 10. 7. 5.

For which requirements do you suggest an sap hana modeling focus rather than sap bw4hana modeling focus? 2 answers. Leverage sql in house knowledge. Report on a harmonized set of master data. Enhance existing sap hana content models. Load snapshots or deltas from different sources on a periodic basis.

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?. sap crystal reports for enterprise. sap lumira designer edition. sap bo web intelligence. sap analysis excel.

Which objects can be affected by the key date in a bw query? 3 answers. Key figures. Hierarchies. Display attributes. Navigational attributes. Conditions.