what is the difference b/w mdx and sql?

Question Posted / ambareesh.ko

4 Answers
21117 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

More Cognos Interview Questions

What is the difference b/w macros and prompt?

0 Answers

Can you define snapshot?

0 Answers

How to publish a package by running Java Script?

0 Answers

How will you migrate your reports to QA environment?

2 Answers Satyam,

What are different events in Report studio?

0 Answers Wipro,

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

0 Answers Infosys,

What is set to be Cognos configuration?

0 Answers

Is there any comparison available for Cognos Reportnet Vs Crystal reports?

0 Answers IBM,

These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com

4 Answers IBM,

what is crosstab space

1 Answers IBM,

please please give me some banking calculations in framework manager.

0 Answers

What is the difference between a cascading report and drill through report?

0 Answers

For more Cognos Interview Questions Click Here