OLAP Servicesgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
Eric, Can I use a remote SQL server 6.5 database as my data source, for building OLAP CUBES, in the SQL Server 7.0's OLAP Services? If yes, how does this work? Any help will be highly appreciated? Thanks Praveer
-- Anonymous, March 19, 1999
Yes, you can populate OLAP cubes on a SQL 7.0 database from a SQL 6.5 database with DTS.
You have to implement what is called a star or a snowflake schema for your databases, and then populate it with your data. DTS can help you to import data but you must build the multidimensional tables to import the data into.
Books online can provide help about using DTS.
Hope this helps,
-- Anonymous, March 22, 1999