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
How do you improve the performance of the Cognos Analytics report
what are the filters in framework manager and report studio?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
how to explain health care project and which reports we can create in health care doain?
What is the use of report studio?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
What is a Cube?
Can you define cognos decision stream?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Can you define dimension?
what is a prompt value in report studio and variables ?
Give the advantages of cognos?
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.
What is the difference between a cascading report and drill through the report?
difference between impromptu and cognos8