anand


{ City } chennai
< Country > india
* Profession * sap bi consultant
User No # 65542
Total Questions Posted # 1
Total Answers Posted # 6

Total Answers Posted for My Questions # 4
Total Views for My Questions # 16094

Users Marked my Answers as Correct # 50
Users Marked my Answers as Wrong # 7
Questions / { anand }
Questions Answers Category Views Company eMail

Why we have only 16 Dimension tables in a cube.Is there any reson.Is it a limitation?

Enteg Technologies, IBM, Infosys, TCS, Wipro,

4 SAP Business One 16094




Answers / { anand }

Question { Accenture, 15100 }

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.

Is This Answer Correct ?    14 Yes 2 No

Question { IBM, 78889 }

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.

Is This Answer Correct ?    13 Yes 1 No


Question { 16922 }

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.

Is This Answer Correct ?    4 Yes 1 No

Question { HP, 7971 }

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.

Is This Answer Correct ?    8 Yes 0 No

Question { IBM, 6112 }

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.

Is This Answer Correct ?    0 Yes 1 No

Question { TCS, 12071 }

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.

Is This Answer Correct ?    11 Yes 2 No