what is the difference b/w mdx and sql?

Question Posted / ambareesh.ko

4 Answers
19510 Views
Cap Gemini, IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference b/w mdx and sql?..

MDX is a multidimensional expression, we can query directly
to OLAP source by using MDX and SQL is a structured query
language, where as we can query to the RDBMS source.
When we r dragging the query items into the report area
automatically MDX generated that query will send to the
OLAP source directly.

Is This Answer Correct ?

15 Yes

4 No

what is the difference b/w mdx and sql?..

Answer / karthik

MDX - Is the Multi Dimensional SQL.
Just like we have SQL for Oracle or MS- SQL (which are
nothing but Relational Data Bases ), The Query or the
Syntax for Multi Dimension Data Source like CUBE or other
OLAP data source use MDX.

So the PowerPlay Transfer uses MDX for building the CUBE.

Is This Answer Correct ?

11 Yes

2 No

what is the difference b/w mdx and sql?..

Answer / pratap gangula

SQL is a standard language for retrieving data from RDBMS
while MDX is a standard language to retrieve the information
from a cube.

Is This Answer Correct ?

9 Yes

0 No

what is the difference b/w mdx and sql?..

Answer / surendra

By using mdx we can retrieve the data from the analysis service where as sql retrieve the data from relational database.

Is This Answer Correct ?

5 Yes

1 No

Post New Answer