Vee,

Not seen this one before, but could it be that the attributes within the
join you're making between the Fact and the Dimension table are "related" in
the right direction... i.e. going From Fact to Dimension, or do you have
them reversed... ?
Are you using what "It" thinks are the correct attributes between the Fact
and the Dimension?
Is there a join there at all? Or is it "orphaned"... 'cept then it wouldn't
be available to be made into a Dimension presumably...?

Have you created the relationship in your DSV, and then made any significant
changes to your Views?
Have you tried right clicking within the DSV and chosen "Refresh" from
within the popup menu?

S'probably none of the above..... but y'never know...

Thanks,

Jeremy Greaves
Fenris Software Consulting, Inc



>From: "Vanessa van Gelder "
><mssqldba-ezmlmshield-x45069989.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: SQL 2005 Dimension failing and error is not helping
>Date: Fri, 28 Sep 2007 15:46:24 +0200
>
>I get this error when I process this dimension. As far as I can tell I am
>linked correctly, the right fields are all linked, is there something I am
>missing here?
>
>Please help :-)
>
>
>
>Errors in the high-level relational engine. The 'dbo_PerUserUpdatingView'
>table that is required for a join cannot be reached based on the
>relationships in the data source view.
>
>
>
>Errors in the OLAP storage engine: An error occurred while the dimension,
>with the ID of 'Allusers', Name of 'All Users' was being processed.
>
>
>
>Errors in the OLAP storage engine: An error occurred while the
>'PractitionerID' attribute of the 'All Users' dimension from the 'UK
>Pharmacy Statistics' database was being processed.
>
>
>
>Tia
>
>Vee
>
>
>
>Vanessa Fredanus- van Gelder| SQL DBA | DXS Systems | Tel. +27 21 853 3317|
>Fax. +27 21 854 7953
>
>When I was young, I used to admire intelligent people; as I grow older, I
>admire kind people. Abraham Joshua Heschel
>
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



MS Sql Server LazyDBA home page