Sunday January 21st 2018




‘MDX’ Archives

Create an MDX Query filter

Applies to: Microsoft Office PerformancePoint Server 2007 Note Before you begin, make sure that you have already created a dashboard, and that you are familiar with both Multidimensional Expressions (MDX) and the SQL Server Analysis Services data cube that you want to use for your filter. For more information about MDX, see the [...]

How to access mdx query builder

1- In business Intelligence Studio, Start new Report project. 2- On the select data source, name your data source, and select Microsoft SQL Server Analyses Services in the type option box and then press edit connection string button. 3- On Connection Properties enter the name of your server and then select Database Name. 4- On report wizard [...]

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 [...]

Difference between DMX and MDX

Difference between DMX and MDX

DMX stands for Data Mining Extensions. The DMX is similar to SQL language and contains statements for data defination and data manipulation. the data defination language includes statements for model creation and data manipulation language contains statements for training the model which includes inserting data into the model and retrieving [...]


Few words about MDX - MDX is not a proprietory language; it is a standards-based query language used to retrieve data from OLAP databases. Many major OLAP providers support MDX including Microdtrategy's Itelligence server, Hypersion's ESSBASE server, and SAS's Enterprize BI server. So it is good be expert in MDX as it is widely used. In coming [...]

Difference between MDX and SQL Language

MDX is language that allows you to query multidimensional databases where as SQL is query language for Relational databases. MDX extract information from Analyses services cubes or dimensions. SQL data is along rows and column, where as MDX data is along multiple axes.

Analysis Services MDX Query Designer User Interface

Analysis Services MDX Query Designer User Interface

Due to large amount of questions on "Analysis Services MDX Query Designer" User Interface  we are providing the details below - Source : SQL Server 2008 Books Online (May 2009) Reporting Services provides graphical query designers for building Multidimensional Expression (MDX) queries and Data Mining Expression (DMX) queries for [...]

Working with the graphical MDX query builder

Since Sql Server 2005 a graphical MDX query builder has been added. This is great feature as it enables developers to use it the same way as they have been using graphical query designer for T-SQL queries. We will be writing a lot about MDX in coming post.

Metrics and Key Performance Indicators

Metrics is a direct numerical measure of business data in the light of one or more dimensions. For example total sale by week, in that case the sale will be a metric and week is dimension. Key Performance Indicators (KPI): is metric that is related to target. KPI represents how far a metric is above or below a pre-determined target. Key [...]

GraphicaL MDX Query Builder

MDX Query Builder  has been included  since Analysis Services 2005 alongwith Cube Wizard that automates many of the many of the steps, prior to that MDX queries has to be hand-coded.  MDX is a query language for multidimensional databases. What it Does ; Use the MDX Query Editor to design and execute statements and scripts written in the [...]