Report Portal

MDX Parameter Sample for SSAS 2005 (Free)

The MDX Parameter sample is a tool that can capture SQL Server Analysis Services (SSAS) MDX query trace with parameter values, and substitute the MDX query parameter names with values. After the MDX parameters are substituted with parameter values, it is easier to debug and test the MDX query in SQL Server 2005 Management Studio.

Scenario

If you have a SQL Server Reporting Services report with dataset that takes report input parameters in MDX query, this utility allows you capture the MDX query if the report returns error or the query result is not expected.

Features

The Activity Viewer sample uses the following SQL Server 2005 features:

  • Application Area Features
  • Overall AMO, ADO.NET, Profiler Trace

Prerequisites

Before you run this sample, make sure that the following software is installed:
• Microsoft SQL Server 2005 database engine
• Microsoft SQL Server 2005 Analysis Services (SSAS)
• Microsoft SQL Server 2005 Reporting Services (SSRS)
• Microsoft SQL Server 2005 workstation tools including SQL Server Profiler.
• .NET Framework SDK 2.0 or Microsoft Visual Studio 2005. The .NET Framework SDK is available free of charge. For more information, see Installing the .NET Framework SDK in SQL Server 2005 Books Online.

Note: This sample does not work with SQL Server 2008.

Read more and download...

 


Tags: tool, ssrs

 

2007-2015 VidasSoft Systems Inc.