what is the difference b/w mdx and sql?
Answers were Sorted based on User's Feedback
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 |
Answer / karthik
MDX - Is the Multi Dimensional SQL.
Just like we have SQL for Oracle or MS- SQL (which are
nothing but Relational Data Bases ), The Query or the
Syntax for Multi Dimension Data Source like CUBE or other
OLAP data source use MDX.
So the PowerPlay Transfer uses MDX for building the CUBE.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / pratap gangula
SQL is a standard language for retrieving data from RDBMS
while MDX is a standard language to retrieve the information
from a cube.
| Is This Answer Correct ? | 9 Yes | 0 No |
What are the different kinds of panes included in cognos?
What are the different types of important services used in cognos?
What is catalog and types of catalogs in cagonos and which is better?
Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.
does query is created for date prompt?
How Metrics Studio is better than Report Studio?
Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.
What are the considerations regarding performance kept in mind while setting up cognos?
can you apply grouping on crosstab?
What is difference between page break and section report?
what is hints in cognos and where we use it.
------------------What is Focalpoint?