Just a question please,
When i browse(query) the cube in analysis services how can i save those queries?Can they be saved anyware?
(By browse i mean explore,drill down data in the Cube Browser of Analysis services 2005.)
Help please !!!
No, you cannot save queries done through the cube browser in the BI Development Studio (BIDS).
You could use Profiler to capture the MDX queries that are sent, but you would then have to use a different tool (like SSMS or Reporting Services) to run those queries. BIDS is not really meant to be a reporting tool. You will need to look at a different tool to do this, Excel pivot tables are probably one of the cheaper, more accessible solutions.
|||
You can capture the queries using SQL Server Profiler:
http://msdn2.microsoft.com/en-us/library/ms174779.aspx
>>
SQL Server 2005 Books Online
Introduction to Monitoring Analysis Services with SQL Server Profiler
You can use SQL Server Profiler to monitor events generated by an instance of Microsoft . By using SQL Server Profiler, you can do the following:
Monitor the performance of an instance of Analysis Services.
Debug Multidimensional Expressions (MDX) statements.
Identify MDX statements that run slowly.
Test MDX statements in the development phase of a project by stepping through statements to confirm that the code works as expected.
Troubleshoot problems in Analysis Services by capturing events on a production system and replaying them on a test system. This approach is useful for testing or debugging purposes and lets users continue to use the production system without interference.
Audit and review activity that occurred on an instance of Analysis Services. A security administrator can review any one of the audited events. This includes the success or failure of a login try and the success or failure of permissions in accessing statements and objects.
