locked
Browse Cube RRS feed

  • Question

  •  
    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 !!!
    Monday, February 19, 2007 11:57 PM

Answers

  • 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.

    Tuesday, February 20, 2007 2:18 AM
  • 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.

    Display data about the captured events to the screen, or capture and save data about each event to a file or SQL Server table for future analysis or playback. When you replay data, you can rerun the saved events as they originally occurred, either in real time or step by step.

    >>

    Tuesday, February 20, 2007 2:18 AM

All replies

  • 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.

    Tuesday, February 20, 2007 2:18 AM
  • 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.

    Display data about the captured events to the screen, or capture and save data about each event to a file or SQL Server table for future analysis or playback. When you replay data, you can rerun the saved events as they originally occurred, either in real time or step by step.

    >>

    Tuesday, February 20, 2007 2:18 AM