Sunday January 21st 2018

Categories

Insider

Archives

MDX query Builder in Sql Reporting services 2008

I would like to share my hands on experience of Query builder in SQL Reporting Services 2008. We created a report in Sql Reporting Services 2008 utilizing Analysis Services Database. We can create MDX queries by drag and drop Dimension and measures in their respective areas. MDX code will be automatically generated and can be viewed by pressing ok. This is great tool in understanding and learning MDX query language.