What are the nine decision points of data ware housing?

Answer Posted / mahesh

1. IDENTIFY FACT TABLE
2. IDENTIFY DIMESNION TABLE
3. DEFINE ATTRIBUTES OF ENTITIES
4. DEFINE GRANULARITY OF FACT TABLE
5. DEFINE AGGREGATES
6. SLOWLY CHANGING VARIABLES
7. PRE CALCULATED KEY FIGURES
8. HOW LONG THE DATA WILL BE KEPT
9. HOW OFTEN THE DATA IS EXTRACTED

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how client access the reports

1123


remodeling is applied only on info cube? why not dso/ods?

1472


explain return tables. How do start routine and return table synchronize with each other?

574


What is the structure of infocube?

534


Hi, I need to know anything and everything abt datamarts and thier behaviours. Please suggest any links/whitepapers/articles which explain datamarts from scratch. This is required for my admin job at hand. Appreciate your help :)

1513






What is data ware-housing hierarchy?

642


In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?

1631


What are value fields?

1407


What are extractors? Name a few which are used commonly in the sap bw?

525


How would you do the optimizing the dimensions

498


What is the use of multi-provider in the sap?

504


How does the time dependency works for bw objects ?

506


What is a constant selection?

1553


What is the precaution you should take when archiving?

1526


What is the difference between ECC 6.0 and 6.4

3087