Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference b/w mdx and sql?
- 4 Answers
- 21181 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
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 tell me the step by step process how to connect cognos to oracle?
What are the differences between main Cognos 8.2 and 8.3 ?
I need to display blue color for max Revenue and red color for min Revenue by using condition formatting how it possible........?
A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt
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.
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
what is the difference between native sql and cognos sql?
What is a Cube?
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?
how to access the database directly from cognos reportnet
1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?
Teradata 
