what is the difference b/w mdx and sql?

Answer Posted / k srinivas

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you improve the performance of the Cognos Analytics report

539


what are the filters in framework manager and report studio?

591


Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

594


how to explain health care project and which reports we can create in health care doain?

6358


What is the use of report studio?

613






please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

1770


What is a Cube?

688


Can you define cognos decision stream?

603


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

577


Can you define dimension?

641


what is a prompt value in report studio and variables ?

2168


Give the advantages of cognos?

581


3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2132


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

735


difference between impromptu and cognos8

1973