How to write [scope] statements in the session cope,not in the cube-mdx-script?
In the book called "Microsoft Analysis Services 2005" written by developers from microsft's ssas2005 team, there is a senctence:
"because scope statements and assignment operators work ony in the context of a cube or session..."
How to do that ?
Thanx.
You can't do a scope statement from Management Studio because Management Studio doesn't set the current cube on the connection string.
If you look at the MDX Script Performance tool (http://www.codeplex.com/mdxscriptperf) that Chris Webb wrote you will see an example of running a scope statement within a session. It specifies the cube in the connection string. And it replays the calc script one statement at a time which is an example of using "scope" in the context of a session.
Hope that helps.
|||Thanx for your answer,which is right absolutely.
But I doubt about the Performance Analyzer according the inner working rule , which can be found in the book called "Microsoft Analysis Services 2005" that is written by developers from SSAS2005.
No comments:
Post a Comment