Convert MDX fields to SQL
December 15th, 2007 in Analysis Services, Blog, Reporting Services, SQL ServerA number of our customers have reporting systems that use both MDX and SQL, retrieving data from both OLAP and SQL Server databases. This generates the problem of converting an MDX field ([Dimension].[Hierarchy].&[Attribute]) into SQL Server field value (Attribute). The following code is a Reporting Services custom code section that will rip off the MDX and leave you with the value. Public Function MDXParamToSQL(Parameter As String,…
» Read more
