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
Explain the difference between native sql and cognos sql?
What is set to be Cognos configuration?
What you mean by drill across and what is the difference between drill through, drill across?
What are the batches and it’s details?
what are the special features in cognos reportnet?
How Metrics Studio is better than Report Studio?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
How can you link a query to a data container manually in Report Studio?
hi my name is siraj i want to know cognos queriy language
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 defined as Cognos Impromptu?
Write types of folders present in cognos?
What are the components used in web tier?
What is a dimension?
What do you mean by drill through report?