hi all
i am defining database dimensions.i am able to define dimensions which are
based on 1 main table.but when i m trying to define dimension based on more
than 1 table or view it won't appear.then i tried bye manually selecting
related tables in Data Source View.But at the time of processing Error
occurs whichs says the joins are not proper


Error 1 Errors in the high-level relational engine. The 'sales' table that
is required for a join cannot be reached based on the relationships in the
data source view.

Error 2 Errors in the OLAP storage engine: An error occurred while the
dimension, with the ID of 'sales 1 1', Name of 'dummy' was being processed.


Error 3 Errors in the OLAP storage engine: An error occurred while the
'production System' attribute of the 'dummy' dimension from the ' trial
'database was being processed.

Can you describe the schema that you set up in the DSV - what is the
role of the 'sales' table, for example?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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