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
what are slowly changing dimensions? Why we are used scd?
What is the complex report you faced in real time?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
can we insert all types of charts in a list report? what r the realtime prompts?
what is catalog and types of catalogs in cagnos and which is better?
What are the batches and it’s details?
Explain the different types of views used in cognos.
Can you define fan trap?
what is the procedure for scheduling conditional rendering?
What are the components used in web tier?
How we check the errors before running the report?
What is the use of Cognos scenario?
How to join multiple db in catalog?
What is meant by junk dimension?
How to do Performence Tunning in Cognos Reports?