Query Designer Generate MDX?

[#1]

Hi guys,

I am trying to get some data from SAP BW 3.5 into a .NET application using the .NET connector. I found a good article on sdn.sap.com on how to do it but I am having some problems writing the MDX.

I have the query I want created in the query designer. Is there a way to generate the MDX for this query so I can use it in .NET? I tried recreating the query and testing it using the mdxtest function in SAP BW but the infocube in query designer doesnt seem to match the one in mdxtest making it difficult to do by hand.

Anyhelp would be great, I am really new to SAP BW so I'm sorry if any of this was confusing.

Thanks,

Drew

[Former Member]

Hi,

As you mentioned, you can create a MDX query through MDXTEST for this you have to select your infoprovider as a Catalog and choose the Query name from the Dropdown list of Cubes and start creating the MDX query from this tool. MDX query runs on the Query not on the infoprovider. It will treat the query as cube and start extracting the data thro the BI query. Establish the connection between the .Net application and the SAP Database and make use of this MDX query in you application

Regards,

Venkat S

[Former Member]

Thank you for the help Venkat. So if I just want the data that query returns, I can just choose that query as the Cube and then do a select all?

[Former Member]

Ya... Will do. You can try that

[Former Member]

Hi venkat is this worked for you?