How do I design the db when anticipating OLAP use?

[HoustonGuy]

I am familiar with Data Wahrehousing/Marts and OLAP and a few tools used to work with it - I want to make sure I understand what needs to be done when designing the original database.<br><br>I really can't see anything that needs to be done differently. The Data Warehouse or Mart will incorporate all of the needed fields and formulas that will allow for successful OLAP use as far as I can see.<br><br>I may be missing the forest for the trees - but what would the dba do differently with the design of the database when anticipating OLAP use?<br><br>Thanks! <p>Cody ford<br><a href=mailto:codyford@yahoo.com>codyford@yahoo.com</a><br><a href= > </a><br>VB, VBS, Seagate Info/Crystal Reports<br>

 

[jnicho02]

Cody, you are right that the OLAP tools will be running on top of a data mart. You might find that some OLAP tools like using pure star schemas and your warehouse/mart may have a more complex design. There may also be considerations with how to store hierarchy information. <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/jnicho02/>my

home</a><br>

 

[HoustonGuy]

Thank you very much for the reply. Just wanted to know that I was on track.<br><br>Your web site is excellent. I have never visited a site that gave me such a mixture of powerful information for my career and entertained me as well. I encourage everyone to visit. <br><br>Kudos my U.K. friend! Well done!<br><br>Cody <p>Cody ford<br><a href=mailto:codyford@yahoo.com>codyford@yahoo.com</a><br><a href= > </a><br>VB, VBS, Seagate Info/Crystal Reports<br>

 

[jnicho02]

Cody, I tried to email you but it bounced.<br> <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/jnicho02/>my

home</a><br>

 

[HoustonGuy]

I changed my address. The new one is now listed as:<br><br><A HREF="mailto:codyjford@hotmail.com">codyjford@hotmail.com</A><br><br>Thanks! <p>Cody ford<br><a href=mailto:codyjford@hotmail.com>codyjford@hotmail.com</a><br><a href= > </a><br>VB, VBS, Seagate Info/Crystal Reports<br>