Skip to Content
Introduction

MDX (multi-dimensional expressions) is a language developed by Microsoft for queries using multi-dimensional data. In this weblog i am going to present a help guide for creating MDX statements for extracting data from BW infocubes or queries.

BW provides MDXTEST transaction which can be used to quickly build MDX statement against infocubes or queries. If you click on “Generate Default MDX Statement” then the transaction automatically generates the MDX template.

image

If you are generating a MDX statement against query then make sure you check the attribute “Release for OLE DB for OLAP” in query designer.

image

Let’s talk about where clause of MDX. In MDX the where clause is used to filter data and this where you specify the slicer condition to slice the data.
If you have more than one slicer condition then you can need use “()” or “{}” for container and “,” to separate the conditions.

Example1: In the following example i am retricting the data to US and fiscal period 1 of 2003.

In MDX statement there is no wild search (*, %..) but you can come close to doing a wild search by specify a range in the slicer condition.

Example2: In the following example i am retricting the data to US and fiscal period 1 of 2003 to fiscal period 12 of 2003.

Now let us talk about SAP variables in the MDX statement. Variables are used to supply variable values for all the variables of a query.

Example3: The following example shows you how to pass a individual value and a range of values.


Note: The same query can also be written the following way.

You can also use the variables to exclude the data.

Example4: The following example shows you how to pass a individual value and a range of values to exclude data.


Note: The same query can also be written the following way.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Ramesh Ramaraju
    Hi Prakash

    Can you pls send me a link where it explains the execution of MDX step by step.  I want to manipulate the existing MDX statement in a query.

    Thanks.

    (0) 

Leave a Reply