Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Paper on approach and architecture of data warehouse

Hi,

<b>Granularity</b>

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

-Reporting capabilities

-Performance

-Space needed

-Load Time

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.

replied

I did notice the special paper only now ... thanks for pointing it out...

We generally use the IBM redbook for data architecture design...

http://www.redbooks.ibm.com/redbooks/pdfs/sg242238.pdf

its one of the best source

and for multidimensional modeling :

http://www.redbooks.ibm.com/redbooks/pdfs/sg247138.pdf

hope this helps...

I know I am not referring to the special paper , but some sources that might be very helpful for the same.

Arun

Assigning points is a way of saying thank you on SDN

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question