SAP BW Interview Questions on Query Design and Analysis
Standard DSO – consists of three tables (activation queue, active data table, and change log). It is completely integrated in the staging process. In other words, data can be loaded into and out of the DataStore Objects during the staging process. Using a change log means that all changes are also written and are available as delta uploads for connected data targets.
True. The same data source may be used to load a SID table and a cube.
Ex: If Vendor ID is a characteristic, its attribute can be vendor name and vendor address.
Direct update DSO – Only has the active data table so not as easily integrated in the staging Process and relies heavily on BAPIs.
5) In query designer, two types of restrictions can be set on the filter tab, what are they?
Q25. PROCESS CHAINS: IF U ARE USED USING IT THEN HOW WILL U SCHEDULING DATA DAILY.
A: delete index, generate index, construct database statistics, initial fill of new aggregates, roll up of filled aggregates, compression of the infocube,activate ODS, complete deletion of data target.
A. Yes, When you want to report on characterstics or master data, you can make them as infoprovider. Ex: you can make 0CUSTMER as infoprovider and do Bex reporting on 0 CUSTOMER;right click on the infoarea and select Insert characterstic as data target.
* – groups according to characteristics H – Hierarchy F – fixed value Blank — none
A: Info package, Read PSA and update data target, Save Hierarchy, Update ODS data object, Data export(open hub), delete overlapping requests.
SAP BW Interview Questions and Answers
| S.No | Star Routine | Conversion Routine |
| 1 | Data packages can be modified anytime | They cannot be modified |
| 2 | Support only internal format | Support both internal and external format in the majority of applications |
| 3 | Routines are bounded | Routines don’t have restriction on them in any of the assigned tasks |
However, if user run the query for Feb 2010 and the planned expense is $2800 for Feb, user will get 11/28 * 2800 = $1100 instead of the whole month expenses number $2800 from the formula. I just wonder how I can set the logic in the query designer to recognize Feb is past and should take an entire month planned expense instead of using the factor to multiple the whole month expenses? If I take out the logic and the user run the query for March 2010, user will get entire month planned expense $3100 instead of $1100. Thanks.
I have a query trying to show MTD planned and actual expense as well as the variance. The period is using month per year. Since the planned expense is entered by month but the actual expense is posted by day, I assume the budget is equally distributed for the whole month and I created an user exit and formula to find out the today date and the number of the day of the current month to calculate the MTD factor times the select current month planned expenses. For example, If user run the report for 3/2010 and the March 2010 budget is $3100 and today date is March 11, the MTD budget will be = 11/31 * 3100 = $1100. That works if the report run for current month.
FAQ
What is a BEx query?
How do I check my BEx query?
- Navigate to Start -> All Programs. Under the folder “Business Explorer”, the “Query Designer” is available. Click on “Query Designer”.
- Select required BW system. Click the Ok button. Enter the Client. User Name. Password. Logon Language. Click the Ok Button.
How do you create a variable in BEx query?
What are all query properties in the BEx Analyzer?
- Description. You can enter or change the query description here.
- Technical Name. Displays the technical name of the query.
- InfoProvider. Displays the technical name of the InfoProvider that the query is based on.
- Key Date. Every query has a key date. …
- Last Changed By. …
- Display Options. …
- Document Links. …
- Result Position.
