A ) Infoset is a kind of InfoProvider.A InfoSet builds up a data Join of basic InfoProviders (DataStoreObjects,InfoObjects,InfoCubes).
A Classic InfoSet provides a View of dataset that you report on.We can use InfoSet query for this purpose.The Classic InfoSet determines which tables or fields with in a table an infoset query references.
2 ) What is the difference between Multiprovider and Infoset ?
A ) See here
3 ) Which table holds the InfoSet Information ?
A ) RSQTOBJ.
4 ) What is the use of function 'Selective Deletion' in the contents tab of the InfoCube ?
A ) See here.
5 ) What is data Integrity ?
A ) Data Integrity is about eliminating duplicate entries in the database.Data Integrity means no duplicate data.
6 ) A Flat File name might change for the uploaded file from day to day.How can we ensure that data will still load even though the file name changes ?
A ) Writing a Infopackage level routine by file name.
7 ) What is index ?
A ) Indexes are used to locate the records in database table quickly.BI uses two types of indexes..
B-Tree Index(for regular tables).
Bit-map Index.(for fact and aggregate tables)
8 ) What is the t-code for Data Archival and its use ?
A ) SARA .It is used to minimize space,query performance and load performance.
9 ) What is OSS ?
A ) OSS is a online supporting system runs by sap to support customers .we can access this by using t-code OSS1.
10 ) What is the use of process chain ?
A ) The use of process chain is to automate the data load process.
11 ) What is Conversion Routine ?
A ) Conversion Routines are used to convert data types from internal format to external/display format vice versa.
12 ) Why does the tRFC error occurs ?
A ) tRFC error occurs when LUW's(Logical Unit of Work's) are not transfered from source system to the target system.
13 ) When does the 'Time Stamp Error' Occurs ?
A ) It occurs when the 'Transfer rule/structure' are internally inactive in the system.This error can also occur whenever the datasources are changed on R/3 side or the datamarts changed in the BW side.
14 ) What is the difference between Display attribute and Navigational attribute ?
A ) The basic difference between the two is that navigational attributes can be used to drill down when reporting where as display attributes cannot be used so.
15 ) What is BW Statistics and its use ?
A ) The set of InfoCubes delivered by Sap as a part of Sap BW which are useful in measuring the performance of how quickly a query is calculated or how quickly the data is loaded into bw.Bw statistics the name suggest are useful in showing data about the costs associated with BW queries,aggregative data,olap,sap bw management.
16 ) What is the function of bw statistics cube ?
A ) BW Statistics cube contains the data related to reporting performance and the data loads of all the infocubes in the bw system.
17 ) What is KPI's(Key Performance Indicators) ?
A ) KPI's are Predefined calculations that render summarized or aggregated information,which is useful in making strategic decisions.
KPI's are also known as performance measure , performance metric measures .
KPI's are put in place and visible to an organization to indicate the level of progress and status of change efforts in an organization.
18 ) Why do we delete the setup tables ?
A ) Initially we don't delete the setup tables but in two conditions we go for delete the setup tables.When we do change in extract structure we go for it.It means changing extract structure is nothing but adding a new fields which are not there before.So to get the required data to avoid redundency we delete and fill the setup tables.Second one is before going for statistical setup we delete the setup table.
19 ) What are the extractors in sap bw ?
A ) 1 ) Application specific
- BW Content extractors
- Customer generated extractors
- Generic Extractors
A ) Return table is used to obtain the multiple records based on single source records.We use the return table in Update rules.
No comments:
Post a Comment