SAP BW HANA Interview Questions (Part 3)

1.?While loading the data, what is the use of “Delete Overlapping Request” variant will do in a process chain ?

When you want to delete the overlapping request from cubes/ADSOs, you can use this variant in a process chain. This is very much useful when the loading is happening everyday and same data is being loaded everyday and request in the cube/adso might double or duplicate the data in the reports.

It is majorly supported the Full Loads and in case, if we are doing Delta Loads, then we need to add multiple others steps in order to get the process work correctly.

2.?How can we do a Selective Deletion in an ADSO and why it is required?

If we wanted to delete some specific values or some specific request from our target, while keeping other values unaffected, then selective deletion can help here.

This selective deletion process is very much helpful when we want to delete the data that is no longer needed for the business or if any incorrect data has been loaded, then we can delete that using the selective deletion.

Selective deletion can be done via process chain path. Go to the Process chain -> DTP -> Manage Target -> More -> Utilities -> Selective deletion option (to provide the selection criteria) -> execute.

We can do selection deletion on the basis of Calmonth, Calyear, Acc no, PID, Plant type etc.

3.?What do you understand by Compound Attribute in SAP BW?

Compounding of a characteristics or attribute basically means combining two characteristics or info-objects to make them act like a unique single primary key.

There are many info-objects which cannot be defined uniquely such as info object “Plant” and they need other info-objects to establish their identity or presence.

Eg “Plant” characteristics on combining with “Storage Location” characteristics, is an example of compounding attribute where Location is compounding attribute of Plant.

4.?Why Alpha Conversion is so frequently used?

Basically it is a conversion routine, where the data records are either used to convert the values from internal to external format or vice versa.

This alpha routine is used by default in BW and for the characteristics of type “CHARACTER”.

If a field is there which of type “CHAR” and numeric field is being given in that, than leading 0’s will be added to it, based on the char size.

Eg Value “1234_” is of 5 digit but char size is 8, then alpha conversion will convert this value as “00001234”.

5.?Suppose if a process chain needs to be tested in test environment, but it could only be triggered through External API, but you can get the API started, because it will lead the other chains/loads to get started and create havoc unnecessary. What will you do?

We will execute the chain, without changing the START VARIANT Settings, by a program “RSPC_API_CHAIN_START” in SE37 Function Module and test the chain in test environment. ?

If you feel any details/answers needs to be added or corrected, pls do let me know. Happy to get your answers :)

#sap #saphana #sapbwhana #sapbw4hana #bw4hana #bwonhana #businesswarehouse #sapinterview #sapbwinterview #interview #interviewquestions #sapconsultant #saphiring #sapjobs #sapjob #consultant

#interviewpreparation #sapguide #sapopening #sapopenings #sapbi #sapbijob

#openings #hiring #jobopening #hire #bengaluru #corporate #banglore?#saphire #saptutorial #sapjobprepare #corporate #accenture #ibm #infosys #wipro #hcl #tcs #bangalore

?