8 January 2014

SAP BI QUESTIONS & ANSWERS-3


SAP BI QUESTIONS & ANSWERS-3 :-



Q) Can number of data sources have one infosource ?
A) Yes of course. For example, for loading text and hierarchies we use different data sources but the same InfoSource.

Q) Brief the dataflow in bw.
A) Data flows from transactional system to analytical system (BW). DataSources on the transactional system needs to be replicated on BW side and attached to infosource and update rules respectively.

Q) what is procedure to update data into data targets ?
A) full and delta.

Q) as we use sbwnn, sbiw1, sbiw2 for delta update in lis then what is the procedure in lo-cockpit ?
A) No LIS in LO cockpit. We will have datasources and can be maintained (append fields). Refer white paper on LO-Cockpit extractions.

Q) Why we delete the setup tables (LBWG) & fill them (OLI*BW) ?
A) Initially we don't delete the setup tables but when we do change in extract structure we go for it. We r changing the extract structure right, that means there are some newly added fields in that which r not before. So to get the required data (i.e.; the data which is required is taken and to avoid redundancy) we delete n then fill the setup tables.
To refresh the statistical data. The extraction set up reads the dataset that you want to process such as, customers orders with the tables like VBAK, VBAP) & fills the relevant communication structure with the data. The data is stored in cluster tables from where it is read when the initialization is run. It is important that during initialization phase, no one generates or modifies application data, at least until the tables can be set up.

Q) significance of ods ?
A) It holds granular data (detailed level).

Q) where the psa data is stored ?
A) In PSA table.

Q) what is data size ?
A) The volume of data one data target holds (in no. of records)

Q) Different types of INFOCUBES.
A) Basic, Virtual (remote, sap remote and multi)

Q) infoset query.
A) Can be made of ODS's and Characteristic InfoObjects with masterdata.

Q) if there are 2 datasources how many transfer structures are there.
A) In R/3 or in BW ? 2 in R/3 and 2 in BW

Q) routines ?
A) Exist in the InfoObject, transfer routines, update routines and start routine

Q) brief some structures used in bex.
A) Rows and Columns, you can create structures.

Q) what are the different variables used in bex ?
A) Different Variable's are Texts, Formulas, Hierarchies, Hierarchy nodes & Characteristic values.
Variable Types are
Manual entry /default value
Replacement path
SAP exit
Customer exit
Authorization

Q) how many levels you can go in reporting ?
A) You can drill down to any level by using Navigational attributes and jump targets.

Q) what are indexes ?
A) Indexes are data base indexes, which help in retrieving data fastly.

Q) is it nessesary to initialize each time the delta update is used ?
A) No.

Q) what is the significance of kpi's ?
A) KPI's indicate the performance of a company. These are key figures

Q) tools used for performance tuning.
A) ST22, Number ranges, delete indexes before load. Etc

Q) process chains: if u has used it then how will u scheduling data daily.
A) There should be some tool to run the job daily (SM37 jobs)

Q) can characteristic info object can be info-provider.
A) Of course

Q) procedures of reporting on multicubes
A) Refer help. What are you expecting ? MultiCube works on Union condition

Q) explain tranpsortation of objects ?
A) Dev---àQ and Dev-------àP

Q) What types of partitioning are there for BW ?
A) There are two Partitioning Performance aspects for BW (Cube & PSA) Query Data Retrieval Performance Improvement: Partitioning by (say) Date Range improves data retrieval by making best use of database [data range] execution plans and indexes (of say Oracle database engine).
B) Transactional Load Partitioning Improvement: Partitioning based on expected load volumes and data element sizes. Improves data loading into PSA and Cubes by infopackages (Eg. without timeouts).

Q) How can I compare data in R/3 with data in a BW Cube after the daily delta loads ? Are there any standard procedures for checking them or matching the number of records ?
A) You can go to R/3 TCode RSA3 and run the extractor. It will give you the number of records extracted. Then go to BW Monitor to check the number of records in the PSA and check to see if it is the same & also in the monitor header tab.
B) RSA3 is a simple extractor checker program that allows you to rule out extracts problems in R/3. It is simple to use, but only really tells you if the extractor works. Since records that get updated into Cubes/ODS structures are controlled by Update Rules, you will not be able to determine what is in the Cube compared to what is in the R/3 environment. You will need to compare records on a 1:1 basis against records in R/3 transactions for the functional area in question. I would recommend enlisting the help of the end user community to assist since they presumably know the data.
To use RSA3, go to it and enter the extractor ex: 2LIS_02_HDR. Click execute and you will see the record count, you can also go to display that data. You are not modifying anything so what you do in RSA3 has no effect on data quality afterwards. However, it will not tell you how many records should be expected in BW for a given load. You have that information in the monitor RSMO during and after data loads. From RSMO for a given load you can determine how many records were passed through the transfer rules from R/3, how many targets were updated, and how many records passed through the Update Rules. It also gives you error messages from the PSA.



2 comments: