The 'TableName' table that is required for a join cannot be reached

 

hi,

i have migrated 2000 2005. when try process cube fails on dimension. try process dimension following error. here details:

 

<batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <parallel>
    <process xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance">
      <object>
        <databaseid>analysis services project1</databaseid>
        <dimensionid>destination country</dimensionid>
      </object>
      <type>processfull</type>
      <writebacktablecreation>useexisting</writebacktablecreation>
    </process>
  </parallel>
</batch>
 processing dimension 'destination country' completed successfully.
  start time: 12/5/2007 9:03:37 pm; end time: 12/5/2007 9:03:37 pm; duration: 0:00:00
  processing dimension attribute '(all)' completed successfully.
   start time: 12/5/2007 9:03:37 pm; end time: 12/5/2007 9:03:37 pm; duration: 0:00:00
  sql queries 1
   select [destcountry].[countryid] [destcountrycountryid0_0]
  from [dbo].[country] [destcountry]
errors , warnings response
 errors in high-level relational engine. 'destcountry' table required join cannot reached based on relationships in data source view.
 errors in olap storage engine: error occurred while dimension, id of 'analysis services project1', name of 'destination country' being processed.

 

when run given query runs successfully:

 

 select [destcountry].[countryid] [destcountrycountryid0_0]
  from [dbo].[country] [destcountry]

 

this query works fine , return correct result set.

destcountry exists in data source view. can shed light on it.

 

after migration of measures have been named col1 ... col23. why migration wizard doing so.

 

thanks in advance help.

this previous forum thread identifies scenarios in error occurs - not sure if you've seen it:

 

error: 'table required join cannot reached'

 

SQL Server  >  SQL Server Analysis Services