something strange happens when i try to create this statement as a named query in a data source view. i think it has to do with the aliases or correllation names but the error message i get is strange...when i validate the query the SQL Syntax checker comes back fine, but when i try to actually execute it, i get SQL Execution Error Executed SQL Statement Select panel.ToString() as panel...but as you can see that I never wrote a ToString function, and furtnermore, the Create Named Query interface changes or removes aliases i have already coded into the query!!...i know i am just not understanding what it wants. but what is wierd is that the code below does execute in SSMS and returns the correct result, but i cannot get it into my data source view...if we cannot do this correctly i will have to materialize this statement into a dummy table just to be able to do the reconciliaton....can you see what is wrong with this query or can i buy a clue as to how to convince the Create Named Query editor to accept it? thanks very much
drew
<<i took the code down because after re-reading it i realized that the DSV query editor changed the references, so any reader would not see the outer reference for the derived table...long story short, my experience is that the DSV query facility is lightweight and if you need to do any preprocessing or derived tables in your query you're better off just materializing it in the relational layer and using it in SSAS DSV instead of trying to do any heavy lifting here.>>
thanks
me