Paper on approach and architecture of data warehouse

[Former Member]

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.

[former_member184494 · Accepted solution]

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

[Former Member · Accepted solution]

Hi,

Thanks for the info. I think I found this when searching the Internet for white papers.

I have been assigning points to all whom have replied, so let me know if I overlooked any.

Thanks. Have a great day.

[Former Member]

RSA1

I have searched for that document in service.sap.com it seems thais document is no more available since this is older version of the BW or I am not sure still it is there atleast I didn't find this. Let's see if some one posts over here.

Thnaks

Sat