Paper on approach and architecture of data warehouse
An important result of the data modeling phase is that the <b>granularity</b> (the level of detail of your data) is determined. Granularity deeply influences
You have to decide whether you really need to store detailed data in an <b>InfoCube</b> or whether it is better in an <b>ODS object</b> or even not stored in your data warehouse at all, but accesses directly from your Source system via <b>drill thru</b>.
These decisions are decisions that do not only influence your current scope, but the entire approach to and architecture of your warehouse.
This topic is discussed in a special paper.
This is emphazised on page 40 from http://help.sap.com/bp_biv235/BI_EN/documentation/Multi-dimensional_modeling_EN.doc
Has anyone read this special or white paper? Where can I get this special paper and start reading it more?
Thanks. Have a great day.
Arun Varadarajan replied
I did notice the special paper only now ... thanks for pointing it out...
We generally use the IBM redbook for data architecture design...
its one of the best source
and for multidimensional modeling :
hope this helps...
I know I am not referring to the special paper , but some sources that might be very helpful for the same.
Assigning points is a way of saying thank you on SDN