SAP BW on HANA Interview Questions

If you're looking for SAP BW on Hana Interview Questions & Answers for Experienced & Freshers, you are in right place. There are a lot of opportunities from many reputed companies in the world. According to research SAP BW on Hana has a market share of about 22.2%.

So, You still have the opportunity to move ahead in your career in SAP BW on Hana. Mindmajix offers advanced SAP BW on Hana Interview Questions 2024 that helps you in cracking your interview & acquire a dream career as  SAP BW on Hana Developer.

SAP BW on HANA Interview Questions and Answers

1. What is the DIM ID?

Dim ids ink dimensions to the fact table.

2. What is the time distribution option in the update rule?

This is to distribute data according to time; for example, if the source contains calendar week and the target contains calendar day, the data is a spit for each calendar day. Here you can select either the normal calendar or the factory calendar.

3. What are the types of attributes?

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 customer characteristics with the country as a navigational attribute; you can analyze the data using customer and country.

4. What is a transnational info cube?

These cubes are used for both reading and write; standard cubes are optimized for reading. The transactional cubes are used in SEM.

5. Give example data sources supporting this?

 2LIS_03_BF and 2LIS_03_UM

6. What is a source system?

Any system that is sending data to BW like R/3, lat file, oracle database, or external systems.

7. Can you partition a cube that has data already?

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.

8. Can you disable cache?

Yes either globally or using query debug tool RSRT.

9. What are the steps to load a noncumulative cube?

1. initialize opening balance in R/3 (S278)
2. activate extract structure MCO3BFO for data source 2LIS_03_BF
3. set up historical material documents in R/3 
4. load opening balance using data source 2LIS_40_S278 
5. load historical movements and compress without marker update. 
6. set up V3 update
7. load deltas using 2LIS_03_BF.

10. What is an info source?

Group of logically related objects; for example, the CUSTOMER info source will contain data related to customer and attributes like customer number, address, phone no, etc.

11. What is global transfer, Nile?

This is a transfer routine (ABAP) defined at the info object level; this is common for all source systems.