SAP BW Interview Series

SAP BW HANA Interview Questions (Part 7)

Do checkout this commonly asked SAP BW on HANA Interview Questions AnswersSeries and prepare for your interviews easily. This is Part 7 of 10 Part Series.

SAP BW HANA Interview Series

1. What is the property of “Inventory Enabled” in an ADSO signifies?

Ans. Inventory Enabled ADSO contains the complete list of records of the information resources which are being used by the organization. When we activate this flag of inventory enabled, two extra tables along with all other standard tables are being activated, which are: Validity Table and Reference Point table.

/BIC/A’NAME’4 : Validity table which basically stores the time intervals for which all the non cumulative data has been loaded to the provider.

/BIC/A’NAME’5 : Reference Point Table is updated when the data is being activated in the inventory enabled ADSO and contained newly updated data with its references.

2. How to Maintain Master Data in SAP BW4HANA?

Ans. In BW4HANA, We have Fiori where we can easily maintain the master data in the cockpit itself. We can go to the portal or cockpit using BW4WEB T-Code and then go to the Info-object screen -> select info-object -> open it -> add rows and maintain the data and save.

Other could be through the eclipse in BW4HANA , open infoobject and maintain master data. It will also lead you to move to cockpit screen only.

3. How to create a variant in SAP BW4HANA?

Ans. There are multiple ways of creating the variant. One through SE38 TCode -> Program Name -> Execute -> Enter all the selections you want to be in a variant -> save -> activate.

Other one could be SE16 -> Give selections -> go to -> save variant -> give name & settings -> save & activate.

Other one could be using process chain variant editor.

4. Tell the use of Expert Routine?

Ans. When you look for any alternative approach for start, end or field routine, then you can use expert routine. But it should only be preferred when the requirement is very complex and could not be completed by other routines.

In special cases only, as expert routine will have both source and target field and their wont be having any mappings between the source and the target fields. Transformation can be done through the code only.

For ex: If you want to transpose the data, sap source has 12 records (one in a month) for the whole year and in target, only one single record is being required with all the months as columns for that year, than we can use expert routine.

5. What are the 3 classifications of data based on Data Tiering Optimization?

Ans. Basically Data Tiering Optimization means to assign data to multiple storage areas. When we classify the data in our source, we classify it as either hot, warm or cold. This classification is done on the basis of how frequently the data is being used and what could be the cost and performance requirement of that data.

Data could be hot, cold or warm.

Hot is when it is critical for the business and for real time processing and the data is being used very frequently. It is stored in SAP HANA itself. It is called as standard tier.

Warn is when the data is used less frequently and stored in extension nodes of SAP HANA itself. It is called as extension tier.

Cold is when the data is rarely used and stored externally in other storages such as Hadoop, SAP IQ etc. It is known as external tier.

Hope you like the SAP BASIS Interviews Series Part 7.

Check out other parts at my website : https://acorporateguy.com/