Showing results for 
Search instead for 
Did you mean: 


Former Member
0 Kudos

Hello experts,

I created a query with BEx Query Designer. Now I want to see the generated MDX expression. Therefore I started transaction mdxtest. But How can I open my query in mdxtest?



Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos


First of all the execution of Bex Query in excel does not go through the MDX engine. We use MDX statements only when we need to connect from third party applications like JAVA,Asp etc.

You can generate a test MDX statement for a query provided the query must be enabled for OLAP. This option is available in the Query Properties in the Designer. Once this is done and query saved , in MDXTEST you need to select the Infoprovider first then it will list the queries which are enabled for OLAP.



Answers (0)