In Sql Server Management Studio once I browse a cube I can drop column fields, row fields and filter fields. This displays the required data.
I want to know if there is a way to view the MDX query being generated behind the scenes to display the data?
Thanks.
Testing MDX QueriesOpen SSMS and connect to the Analysis Services server. Right-click on the SSAS database and click New Query -> MDX to open and create a new MDX query. Press Ctrl+V to paste the query text that you captured in the profiler.
After you deploy a cube, the cube data is viewable on the Browser tab in Cube Designer, and the dimension data is viewable on the Browser tab in Dimension Designer. Browsing cube and dimension data is way to check your work incrementally.
Open Microsoft SQL Server Management Studio. On the Connect to Server page, select Analysis Services for Server type. Enter the name of the server that contains the Analysis Services database for the General Ledger cube, enter credentials used to access the server, and then click Connect.
In SQL Server Management Studio, open the instance that contains the tabular model you want to query. Right-click the database icon, select New Query, and then select MDX. In Template Browser, in Analysis Services Templates, open MDX, and then open Queries.
SQL Server Profiler works on SSAS servers. Select Analysis Services for the Server type in the Connection dialog when initiating a Profiler connection. Select your Analysis Services server and connect. You can use the Standard Profiler template and start the trace. You should be able to see the MDX query that way.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With