What steps are involved to upload non cumulative cubes?
Ans:
The steps that are involved to upload non cumulative cubes are:
Initialize opening balance in R/3 (S278).
Activate extract structure MC03BF0 for data source 2LIS_03_BF.
Setup historical material documents in R/3.
Load opening balance using data source 2LIS_40_s278.
Load historical movements and compress without marker update.
Setup V3 update.
Load deltas using 2LIS_03_BF.
12
For info object what is the transfer routine?
Ans:
The transfer routine is like a start routine, this is independent of the data source and valid for all the transfer routines, it can be used this to define global data and global checks.
13
What are the load process and processing?
Ans:
The load process and processing are the Info package, Read PSA and update data target, save hierarchy, update ODS data object, data export open hub, delete overlapping requests.
14
What is DIM ID?
Ans:
DIM ID is a link dimensions to the fact table.
15
What is the data target administration task?
Ans:
The data target administration target is to delete index, generate index, construct database statistic, initial fill of new aggregates, roll up of filled aggregates, compression of the info cubes, activate ODS, complete deletion of data target.
16
Give the Step to Step approach to archiving cubes?
Ans:
The Step to Step approach to Archiving Cubes is:
Double click on the cube or right click and select change.
Extras > Select archival.
Choose fields for selection like 0CALDAY, 0CUSTOMER, etc.
Define the file structure maximum file size and maximum number of data objects.
Select the folder logical file name.
Select the delete options not scheduled, start automatically or after event.
Activate the cube.
Cube is ready for archival.
17
How many extra partitions are possible to create and why?
Ans:
Actually two extra partitions are created to accommodate data before that begin date and after the end date.
18
When there is a locking problems what is the parallel process?
Ans:
The parallel process for locking problems:
Hierarchy attributes change run.
Loading master data from same info objects, for example avoiding master data from different sources system at the same time.
Rolling up for the same info cube.
Selecting deletions of info cube/ODS and parallel loading.
Activation or deletion of ODS object when loading parallel.
19
What is the procedure to convert an info package group into a process chain?
Ans:
The procedure to convert an info package group into a process chain is by double clicking on the info package group, click on the Process Chain Maintenance button and type in the name and description, the individual info packages are inserted automatically.
20
How does a data transform through open Hub?
Ans:
The data can be transformed through open Hub by using BADI.