Explore topic-wise InterviewSolutions in .

233.

233.

248.

248.

INFO CUBE model is extended STAR SCHEMA.

Info cube model is extended star schema.

There are 4types:
1. CHAR
2. NUMC
3. DATS
4. TIMS

There are 4types:
1. CHAR
2. NUMC
3. DATS
4. TIMS

YYYYMMDD.

YYYYMMDD.

USE the REPORTING agent for this from the AWB. Click on the EXCEPTION icon on the left;GIVE a NAME and description. Select the exception from query for reporting(drag and drop).

Use the reporting agent for this from the AWB. Click on the exception icon on the left;give a name and description. Select the exception from query for reporting(drag and drop).

If you select characterstic VALUE with replacement PATH then it used the RESULTS from previuos query; for ex: let us assume that u have query Q1 which DISPLAYS the TOP 10 customers, we have query Q2 which gets the top 10 customers for info object 0 customer with as a vairable with replacement path and display detailed report on the customers list passed from Q1.

If you select characterstic value with replacement path then it used the results from previuos query; for ex: let us assume that u have query Q1 which displays the top 10 customers, we have query Q2 which gets the top 10 customers for info object 0 customer with as a vairable with replacement path and display detailed report on the customers list passed from Q1.

I_Step is USED in ABAP CODE as a CONDITIONAL CHECK.

I_Step is used in ABAP code as a conditional check.

Run Bex analyzer -> Business Explorer menu item -> INSTALLATION check; this shows an EXCEL sheet with a start button; click on it; this VERIFIES the GUI installation ;if U FIND any errors either reinstall or fix it.

Run Bex analyzer -> Business Explorer menu item -> Installation check; this shows an excel sheet with a start button; click on it; this verifies the GUI installation ;if u find any errors either reinstall or fix it.

* - groups ACCORDING to characterstics.

• H - HIERARCHY.
• F - FIXED VALUE.
• Blank --- none.

* - groups according to characterstics.

The sets of CUBES delivered by SAP is used to MEASURE performance for query, loading DATA etc., It also SHOES the usage of aggregates and the cost associated with then.

The sets of cubes delivered by SAP is used to measure performance for query, loading data etc., It also shoes the usage of aggregates and the cost associated with then.

1. WATCH the ABAP code in transfer and update rules;
2. load BALANCE on different servers
3. indexes on source tables
4. use fixed length files if U load data from flat files and put the file on the application server.
5. use CONTENT extractor
6. use PSA and data target inparallel OPTION in the info package
7. start several info packagers parallel with different selection options
8. buffer the SID number ranges if u load lot of data at once
9. load master data before loading transaction data.

1. watch the ABAP code in transfer and update rules;
2. load balance on different servers
3. indexes on source tables
4. use fixed length files if u load data from flat files and put the file on the application server.
5. use content extractor
6. use PSA and data target inparallel option in the info package
7. start several info packagers parallel with different selection options
8. buffer the SID number ranges if u load lot of data at once
9. load master data before loading transaction data.

USING BADI.

Using BADI.

DOUBLE Click on the info PACKAGE grp, click on the 'Process Chain Maint' button and TYPE in the name and descrition ; the individual info packages are INSERTED automatically.

Double Click on the info package grp, click on the 'Process Chain Maint' button and type in the name and descrition ; the individual info packages are inserted automatically.

1. heirachy attribute change run
2. loading MASTER data from same infoobject; for ex: AVOID master data from different source systems at the same time.
3. rolling up for the same info cube.
4. selecting deletion of info cube/ ODS and parallel loading.
5. activation or DELECTION of ODS object when loading parallel.

1. heirachy attribute change run
2. loading master data from same infoobject; for ex: avoid master data from different source systems at the same time.
3. rolling up for the same info cube.
4. selecting deletion of info cube/ ODS and parallel loading.
5. activation or delection of ODS object when loading parallel.

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.

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.

Info packake, Read PSA and UPDATE data target, Save HIERARCHY, Update ODS data object, Data export(open hub), DELETE overlapping requests.

Info packake, Read PSA and update data target, Save Hierarchy, Update ODS data object, Data export(open hub), delete overlapping requests.

1. double click on the cube (or right click and select change)
2. Extras -> Select archival
3. Choose FIELDS for selection(like 0CALDAY, 0CUSTOMER..etc)
4. DEFINE the FILE structure(max file size and max no of data OBJECTS)
5. Select the folder(logical file name)
6. Select the delete OPTIONS (not scheduled, start automatically or after event)
7. activate the cube.
8. cube is ready for archival.

1. double click on the cube (or right click and select change)
2. Extras -> Select archival
3. Choose fields for selection(like 0CALDAY, 0CUSTOMER..etc)
4. Define the file structure(max file size and max no of data objects)
5. Select the folder(logical file name)
6. Select the delete options (not scheduled, start automatically or after event)
7. activate the cube.
8. cube is ready for archival.

1. INITIALIZE openig balance in R/3(S278)
2. Activate extract structure MC03BF0 for data source 2LIS_03_BF
3. setup historical material docus in R/3.
4. LOAD OPENING balance using data source 2LIS_40_s278
5. load historical movements and compress without marker update.
6. setup V3 Update
7. load deltas using 2LIS_03_BF

1. Initialize openig balance in R/3(S278)
2. Activate extract structure MC03BF0 for data source 2LIS_03_BF
3. setup historical material docus in R/3.
4. load opening balance using data source 2LIS_40_s278
5. load historical movements and compress without marker update.
6. setup V3 Update
7. load deltas using 2LIS_03_BF

Yes, When you want to report on characterstics or MASTER data, you can make them as info provider. Ex: you can make 0CUSTMER as info provider and do Bex reporting on 0 CUSTOMER;right click on the info AREA and select INSERT characterstic as data target.

Yes, When you want to report on characterstics or master data, you can make them as info provider. Ex: you can make 0CUSTMER as info provider and do Bex reporting on 0 CUSTOMER;right click on the info area and select Insert characterstic as data target.

Time dimensions are automatically CONVERTED; EX: if the CUBE CONTAINS calender month and your TRANSFER structure contains date, the date to calender month is converted automatically.

Time dimensions are automatically converted; Ex: if the cube contains calender month and your transfer structure contains date, the date to calender month is converted automatically.

Use as many as possible for performance improvement; Ex: Assume that u have 100 PRODUCTS and 200 CUSTOMERS; if you make one dimension for both ,the size of the dimension will be 20000; if you make individual dimensions then the total number of rows will be 300. Even if you put more than one characterstic per dimension, do the math considering worst case senerio and decide which characterstics may be combined in a dimension.

Use as many as possible for performance improvement; Ex: Assume that u have 100 products and 200 customers; if you make one dimension for both ,the size of the dimension will be 20000; if you make individual dimensions then the total number of rows will be 300. Even if you put more than one characterstic per dimension, do the math considering worst case senerio and decide which characterstics may be combined in a dimension.

ASSIGN info object, Assign a Constant , ABAP ROUTINE or a FORMULA.

Assign info object, Assign a Constant , ABAP routine or a Formula.

SAP is using fact table PARTITIONING to IMPROVE the performance. you can PARTITION only on 0CALMONTH or 0FISCPER.

SAP is using fact table partitioning to improve the performance. you can partition only on 0CALMONTH or 0FISCPER.