Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datamarts and datacubes

Status
Not open for further replies.

TLiberty

Programmer
Nov 22, 1999
27
US
I am brand new to SQL Server and using V 7.0. We had a discussion today and i was TOTALLY LOSTS. Could someone explain how to implement a DataMart and DataCubes. (Not code, but just a general idea).<br>
<br>
Thanks.
 
Have a look in the 'Data Management: Data warehousing general discussion' and 'Data Management: OLAP' forums for discussions on what they are.<br>
<br>
This is a relevant SQL Server question because Microsoft have added 'OLAP Services' to SS7 - it is a very quick, easy and cheap way to get started with DataCubes, etc. which are essentially a way to give users a flexible way to analyse data in a database.
 
That's a great suggestion!&nbsp;&nbsp;In case you are to install OLAP Services as part of your MS SQL Server 7.0, the tutorial is very helpful and concise.&nbsp;&nbsp;It runs you through the creation of the cubes and uses a &quot;Foodmart&quot; database for your cube creation.&nbsp;&nbsp;Check it out!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top