1 ) What is partitioning and use of partition in infocube ?
A ) Partitioning is nothing but splitting a table either row wise or column wise based on the fields available which would enable a quick reference to the required values of the fields in the tables.
By partitioning an infocube the reporting performance is enhanced because it is easier to search in smaller tables.
2 ) On which infoobjects you would do infocube partitioning ?
A ) We can do infocube partitioning based on one of the following date based infoobjects.
3 ) What is 0REQUID and it use?A ) Partitioning is nothing but splitting a table either row wise or column wise based on the fields available which would enable a quick reference to the required values of the fields in the tables.
By partitioning an infocube the reporting performance is enhanced because it is easier to search in smaller tables.
2 ) On which infoobjects you would do infocube partitioning ?
A ) We can do infocube partitioning based on one of the following date based infoobjects.
- Calendar month (0CALMONTH).
- Fiscal year/period (0FISCPER).
A ) 0REQUID is an infoobject of the request id.It enables bw to distinguish between different data loads.
Whenever data load happens in the data targets it maintains request id automatically for each load.
Whenever we compress the cube the request id's compressed to one.
4 ) What internally happens when bw objects like infoobject , infocube or dso are created and activated ?
A ) When an object(InfoObject,InfoCube,Dso) is created BW maintains a saved version of that object but doesnot make it available for use.
When an object(InfoObject,InfoCube,Dso) is activated BW maintains a active version of that object and makes it available for use.
5 ) Can u add programs in the scheduler ?
A ) Yes.Through Event Handling.
6 ) What is the use of partitioning characteristic in CO-PA ? (Accenture)
A ) For easier parallel search and loading of data.
7 ) What is the use of start routine in update rules ? (Accenture)
A ) The start routine is run at the start of the transformation.The start routine has a table in the format of the source structure as input and output parameters.
Start routines are used to perform preliminary calculations and store them in a global structure or in table.The structure or table can be accessed from other routines.
8 ) What happens when u load transaction data without master data ?
A ) Transaction data will be loaded and master data fields remains blank.
9 ) Can we extract hierarchies from r/3 to CO-PA ?
A ) No.No hierarchies in CO-PA.
10 ) How many hierarchy levels can be created for characteristic infoobject ?
A ) Maximum 98 levels.
11 ) What is the use of function 'reconstruction' tab in infocube ?
A ) It reconstructs the deleted requests from the infocube.One can use reconstruction tab to see the data even after deleting the request.It will gets the data from PSA to InfoCube.
12 ) What is the use of 'field name for partitioning' in CO-PA ?
A ) It is used to decrease the package size.
13 ) What is the t-code for query monitor ?
A ) RSRT.
14 ) What is a data mart ?
A ) Data Mart is a concept which makes it possible to load the data from one Infoprovider to another Infoprovider in the same bw system.
15 ) How do load the data from one Infocube to another Infocube ?
A ) Through Data Marts.
16 ) What is Operating concern in CO-PA ?
A ) An Operating conccern is an organizational unit in financials.It is the valuation level of Profitability Analysis (CO-PA).It is a set of characteristics based on which we want to analyze the performance of a company.
17 ) Is co-pa delta capable ?
A ) Yes .
18 ) What is the difference between value fields and key figures in CO-PA ?
A ) Value fields comprises of data which CO-PA gets from various modules in r/3.
Key figures are derived from these value fields.
19 ) In which of the Dso table maintains a field 0RECORDMODE ?
A ) In all three(New,Change log,Active data) tables we can find the 0RECORDMODE.But it maintains a values inChange Log table only.
20 ) What happens internally when we create an Infopackage ?
A ) Infopackage acts like a interface between source system and data source.When we create an Infopackage it will transfer the data from source system to data source.
No comments:
Post a Comment