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 is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?
how can you create a project creation
What is the difference between Open Connection command ang Open Session Command?
What is main advantage datawarehousing over oracle?
How to do Performence Tunning in Cognos Reports?
------------------What is Focalpoint?
How to Reset Pagenumbers in one report.
wat is bus schema?
whis meant by Thumbnails on cagnos?
How can I disable the drill-down for the last level of my dimensional hierarchy ????
3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?
1 Answers IBM, Thomson Reuters,
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file