data ware house and analyis services

[kirun]

hi there

I m working on SQL sever 2000. How can we can we make datawarehouse out of a already built database. Actually we are working or i would rather say experimenting on OLAP . When we start on this we havent have a slightest idea on OLAP .but as we worked on that we found that there are dataware houses and datamining techniques in that .But before knowing this we have built all fact tables and all cubes etc etc.Now we want that there should a dataware house so that we can mine our cubes and get the results..I need to know that is that possible that we can now make a dataware house.. OR any one can just point out our mistake or can point out the guidline that how can we make the dataware house. And what are the factors which must be in out mind before making a database can n e busy just point out the website or any sort of resource which can help us in this matter

One more thing does n e buddy know n e sort of tool in sql server which will give the result of data mining or of cubes in graphical way or in visual way.. not in that way which sql server shows in meta data pane. form example plyanalysit and procalrity..

thanks in advance

 

[P1Daniels]

SQL Server does not contain any visualization tools and Analysis Services only has basic data checking tool...You can connect to an Analysis Services cube using Microsoft Excel and swet up graphing there...(Open MS Excel...Get External Data...then point to the cube..). You may need to install the latest MDAC...see MSDN site.