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 can you get the errors in job? when loops are araised we get error?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is difference between content store and content manager?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
What is a Pivot?
Explain the difference between native sql and cognos sql?
What are all the types of gateway used in Cognos?
How can we create a dynamic column name in cognos?
What is main difference mapplets and mapping?
Define dimensions?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
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?
Can you define bitmap index?
Is it possible to join multiple Databases in a Catalog?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days