December 2012 Entries

SSAS: Executing MDX Scope statements using SSMS
So usually when I want to test an MDX expression in SSMS I'll write a query with a "WITH MEMBER…" clause to create a query scope calculated measure. But sometimes you may want to test a scoped assignment before putting it in your cube script. The following steps show you how to do this. 1. Click on the button to open an new MDX window, enter your server name and then click on the "Options >>" button 2. You must then specify the database that you are using 3. Then under the "Additional Connection ......

Posted On Wednesday, December 19, 2012 6:52 PM | Comments (5)