SAP BI

Interview Questions: 1. We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario . 2. We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario 3. In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow. 4. when u creating infoobject it shows reference and template what is it 5. what is meant by compounding attribute tell me the scenario? 6. I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen? 7. I have 10 cubes I created multiprovider I want only 1 cube data what u do? 8. what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer? 9. I have 80 queries which query is taking so much time how can you solve it 10. In compression level all requests are becoming zero whi...

"Queued delta" update method: With queued delta update mode, the extraction data (for the relevant application) is written in an extraction queue (instead of in the update data as in V3) and can be transferred to the BW delta queues by an update collective run, as previously executed during the V3 update. After activating this method, up to 10000 document delta/changes to one LUW are cumulated per datasource in the BW delta queues. If you use this method, it will be necessary to schedule a job to regularly transfer the data to the BW delta queues (by means of so-called "update collective run") by using the same delivered reports as before (RMBWV3); instead, report RSM13005 will not be provided any more since it only processes V3 update entries. As always, the simplest way to perform scheduling is via the "Job control" function in LBWE. SAP recommends to schedule this job hourly during normal operation after successful delta initialization, but there is no ...

What is the different delta updates and when to use which updates? Delta loads will bring any new or changed records after the last upload. This method is used for better loading in less time. Most of the std SAP datasources come as delta enabled, but some are not. In this case you can do a full load to the ODS and then do a delta from the ODS to the cube. If you create generic datasources, then you have the option of creating a delta on Calday, timestamp or numeric pointer fields (this can be doc number, etc). You'll be able to see the delta changes coming in the delta queue through RSA7 on the R3 side. To do a delta, you first have to initialize the delta on the BW side and then set up the delta. The delta mechanism is the same for both Master data and Transaction data loads. There are three deltas: Direct Delta: With this update mode, the extraction data is transferred with each document posting directly into the BW delta queue. In doing so, each document posting with delta ext...

 Infocubes have a multidimensional structure with dimension tables(max 16, 13 custom) and one fact table. they are meant for summarised records.  ODS store data at a more granular level. they have flat structures like a table in R/3. They have a unique feature "overwrite" which is absent in case of cubes.  You can use ODS to load to cube further.  Anyway, one major difference is the manner of data storage. In ODS, data is stored in flat tables. By flat we mean to say ordinary transparent table whereas in a CUBE, it composed of multiple tables arranged in a STAR SCHEMA joined by SIDs. The purpose is to do MULTI-DIMENSIONAL Reporting  Another difference is : In ODS, you can update an existing record given the KEY. In CUBES, theres no such thing. It will accept duplicate records and during reporting, SUM the keyfigures up. Theres no EDIT previous record contents just ADD. With ODS, the procedure is UPDATE IF EXISTING (base from the Table Key) otherwise ADD RECORD.  ODS Sto...

The exam contains 80 questions and the time allotted for this 3 hours. Time duration is more than enough for 80 questions. The only thing you should have is Patience because you really get tired after reading all this questions and the respective 5 options for each question and that too confusing ones. The exam is divided in to 6 sections. The first section is Extraction and in this section you have 16 questions. The Second section is based on Reporting and this section contains the maximum number of question compared to other sections. The total numbers of questions in this section are 26. It test your knowledge completely on BEx tool. The note in BW CLASS INPUT FOR REORTING is really excellent. Make sure that you also go through REPORTING MADE EASY GUIDE. You don't have to go through all 500 pages. Just read chapters 3,4,6,7 and 8. It just takes 2 days to read these chapters in detail. When you read these guide try to work on the system as much as possible and build as many queri...

Responsibilities of an implementation project... For ex, Lets say If its a fresh implementation of BI or for that matter you are implementing SAP... First and foremost will be your requirements gathering from the client. Depending upon the requirements you will creat a business blueprint of the project which is the entire process from the start to the end of an implementation... After the blue print phase sign off we start off with the realization phase where the actual development happens... In our example after installing the necessary softwares, patches for BI we need to discuss with the end users who are going to use the system for inputs like how they want a report to look like and what are the Key Performance Indicators(KPI) for the reports etc., basically its a question and answer session with the business users... After collecting those informations the development happens in the development servers... After the development comes to an end the same objects are tested in quality...