Question { Accenture, 16171 }

why u go for aggregate? tell me one example?

Answer

Aggregates are the Small Cubes.We create Aggregates only on
Cubes.We use this Aggregates to Improve the Reporting
Performence.Inspite of fetching the Whole data from Cube we
can selectively Fetches the data with aggregates.

Question { IBM, 81818 }

How many types of Routines in SAP BI(7.0)?

Answer

Hi Good Morning.
In BI 7.0 SAP has Introduced 3 Routines.
1.Start Routine 2.End Routine 3.Expert Routine.

1.Start Routine:-a.It Executes before Transformations.We can use same Routine in same cube in number of times,Its a Global.The program executes Packet by packet.Mostly go for start Routine to Filter the Records.

2.End Routine:-It Executes After the Transformations.Its Also Global & Executes packet by packet.Mostly go for End Routine to Add up the Fields to the Target.

3.Expert Routine:-If you use Expert Routine,Start Routine and End Routines are in De active Mode.Mostly We go for this When We want to filter the Records and we want to add up the fields to the Target at that time we go for this.

4.Field Routine:-We Write this in Info package level or in Transformations.This Routine is Executes Record by Record.This is permitted for that Field only. This is Used for Calculations Etc.

Question { 17906 }

Can anybody explain the what is "OLTP"(Online Transaction
Processing) and "OLAP"(Online Abaytical Processing) in SAP
BW/BI? and also plz explain What is the differences between
those two?


Thanks in advance,
Phani

Answer

OLTP:--
1.Its a Two dimensional Analysis.
2.We can store the data in a limited Period.
3.Here detailed Level of information is available.

OLAT:--
1.Its a multidimensional Analysis.
2.we can store the data more than 5 years.
3.Here Summerised level of information is available.

Question { HP, 8600 }

Why we are going for customization? Give me a scenario..

Answer

If There is not a business content objects then v go for
creating or custamizing.

Question { IBM, 6825 }

what is the use of Data Mart?

Answer

For overwriting Data.Ex" we used to load Flat file data
from DSO to Cube.Its is Data Mart.Loading data from a
infoprovider used as data target to another data target.The
concept we used is DATA MART.

Question { TCS, 12757 }

What are three dimensions provided by SAP?

Answer

There are three Dimensions provided by SAP.Those are
1.Data Packet Dimension.
2.Unit Dimension.
3.Time Dimension.