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 |
how to explain health care project and which reports we can create in health care doain?
In an existiing Framework model, how will you add a new column to the existing table?
What is snapshot thumbnail
----------How to cretae a Template?
Explain about scorecarding?
how to perform single sign in cognos by using url?
What is snapshot ?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please
How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)
what is an associated query?
how u provide security to reports??how u provide security to packages ?