Calc Measure Immediate Viewing

This is probably obvious, but....

In MSAS 2000, I could immediately view the new calc measure in Analysis Manager without rebuilding the cube. Is this still possible in SSAS 2005? Can you list the steps?

Yes you can using the new MDX debugger.

When in BIDS, in the caluclaiton tab, create your calculated member and then select the Debug menu and start debuggging.

The cube browser will appear just beneath the calculaiton script.

You can not only step by step through your various caluclaiton, but you can also change them and see the impact immediately.

It is a full fledge VS debugger for MDX...

|||

Thierry,

Thanks for the answer. It was very helpful.

I've read that you can develop in Online Mode in the BI Studio to get the same affect as in Analysis Manager (AS 2000). What is the difference between using the debugger in project mode and seeing the change immediately online mode? Are there pros and cons to using online mode versus project mode?

Justin