hai

can we use our relation tables as our dimension tables.or is there any
procedure to convert relational table to dimensional table.


thank you

SQL Server Analysis Services can directly read relational dimensional
tables. In past versions of Essbase, relational tables had to be
converted before dimensions could be loaded - don't know whether that's
still true.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***