Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

what is MDX on earth? some questions ...

Hello gurus

I am planning to use a 3-party tool to make query to acccess data within SAP BW, which intends to replace Bex tools. I heard that OLE DB/OLAP BAPI/XMLA are three options of interfaces, and all those three interfaces are based on MDX. After rough investigation, I found that MDX is a standard query language to query MOLAP storage data. So I have the following questions:

1. Since MDX only serves for MOLAP data storage, shall I firstly need to convert all the relative infocube in SAP BW from relational data storage into multidimensional data storage?

2. Since MOLAP only serves for MS SQL 2000 database, so if we use oracle as SAP BW database server, then we cannot use MOLAP? and cannot use MDX?

3. How to use MDX? Shall I firstly use tcode MDXTEST to generate the MDX code for certain infocubes, and then copy such code into 3-party tool?

can anybody answer my questions or part?

thank you very much!

replied

Hi,

<i>1) Since MDX only serves for MOLAP data storage, </i>

This is wrong statement .You can use MDX on ROLAP also.

<i>shall I firstly need to convert all the relative infocube in SAP BW from relational data storage into multidimensional data storage?</i>

No need.

2. <i>Since MOLAP only serves for MS SQL 2000 database, so if we use oracle as SAP BW database server, then we cannot use MOLAP? and cannot use MDX?</i>

You can use it .

With rgds,

Anil Kumar Shrma .P

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question