12th April, 2021
Are you planning to attend an interview for SAP BW on the Hana Developer role but confused on how to crack that interview and also what would be the most probable SAP BW on Hana interview questions that the interviewer may ask? Well, you have reached the right place. Tekslate has collected the most frequently asked SAP BW on Hana interview questions which are often asked in multiple interviews.
Most frequently asked SAP BW on HANA Interview Questions
Ans: This is to distribute data per time; for example, if the source contains calendar week and the target contains calendar day, the data is a spit for each calendar day. you can select either the normal calendar or the factory calendar.
Ans: The SAP HANA database is developed in C++.
Ans: In traditional data warehouses, such as SAP BW, a lot of pre-aggregation is done for quick results. That is the administrator (IT department) decides which information might be needed for analysis and prepares the result for the end-users. This results in fast performance but the end-user does not have flexibility.
The performance reduces dramatically if the user wants to do an analysis of some data that is not already pre-aggregated. With SAP HANA and its speedy engine, no pre-aggregation is required. The user can perform any kind of operation in their reports and does not have to wait for hours to get the data ready for analysis.
Ans: Display only and navigational; display only attributes are only for display and no analysis can be done; navigational attributes behave like regular characteristics; for example, assume that we have a customer characteristics with the country as a navigational attribute; you can analyze the data using customer and country.
Column based tables:
Want to acquire industry skills and gain complete knowledge of SAP BW on HANA? Enroll in Instructor-Led live SAP BW on HANA Training to become Job Ready!
Ans: No; the cube must be empty to do this; one workaround is to make a copy of cube A to cube B; export data from A to B using export data source; empty cube A; create a partition on A; re-import data from B; delete cube B.
Ans: DIM ID: are used to connect fact tables and dimension tables
Ans: A structure consisting of InfoObjects without persistence for connecting two transformations
Ans: The following steps to load a non-cumulative cube
|Property||Row Store||Column Store||Reason|
|Transactions||Faster||Slower||Modifications require updates to multiple columnar tables|
|Analytics||Slower even if indexed||Faster||Smaller dataset to scan, inherent indexing|
|Check out our blog on the SAP BW Tutorials|
Ans: These cubes are used for both reading and write; standard cubes are optimized for reading. The transactional cubes are used in SEM.
Ans: 2LIS_03_BF and 2LIS_03_UM
Ans: Any system that is sending data to BW like R/3, lat file, oracle database, or external systems.
Ans: Yes, either globally or using query debug tool RSRT.
Ans: This is a transfer routine (ABAP) defined at the info object level; this is common for all source systems.
Ans: Multi-provider is a type of info-provider that contains data from a number of info-providers and makes it available for reporting purposes.
Multi-provider does not contain any data. The data comes entirely from the info providers on which it is based. The info-providers are connected to one another by union operations. Info-providers and Multi-providers are the objects or views relevant for reporting. A multi-provider allows you to run reports using several info-providers that are, it is used for creating reports for one or more than one info-provider at a time.
Ans: You can convert the package group into a process chain by double-clicking on the info package group, then you have to click on the ‘ Process Chain Maint ‘ button where you have to type the name and description, this will insert individual info packages automatically.
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .
Write For Us