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 |
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
7. What is performance tuning?
what is catalog and types of catalogs in cagnos and which is better?
what r the names of the reports that u prepared???
9 Answers Covansys, IBM, Wipro,
I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?
There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?
pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com
-------------What is Coditional Prompting?
what is the difference between list report and crosstab report?
What are the batches and it’s details?
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?