Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSAS Design

Author  Topic 

rookie_sql
Constraint Violating Yak Guru

443 Posts

Posted - 2009-11-12 : 05:53:24
Hi I've a table that contains measures and dimensions columns. The tables i populated from a extract file that i get daily.

When i go to build my cube i need to be able to divide up the table into the measures and dimensions that i need. Whats the best solution to about this. Am thinking of creating a view which will be of the dimensions in the extract and joining it back to the main table which will hold all the measures. The join will be by an ID column.
   

- Advertisement -