>I wanted to run this sample, but I don't see such tables in any of the AdventureWorks database version I have. Could you please post a version of this query I can run?
>
>Or you should not run it in SSMS query window?
>
>Naomi, if you'll re-read her question, she referenced Analysis Services,which means OLAP databases. Yes, you'd run the query in SSMS, but only after connecting to the local SSAS server. (And the query would only run if you've built the demo SSAS AdventureWorks project)

Thanks, that's on my list of things to learn.