what is the difference b/w mdx and sql?
Answer Posted / k srinivas
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 |
Post New Answer View All Answers
What is called materialized view?
What is the difference between ‘macro’ and ‘prompt?
What is the size of the cube?
What are all the types of gateway used in Cognos?
What is the model filter?
What are the methods by which it non-durable model could be changed into the durable model?
What are the components of report net?
Can you explain a cognos controller?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
How to create a cube in Transformer? What is the process? Please mention process thank u
how you create security to reports?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
--------------Diff b/w ODS and OLAP?
What are the considerations regarding performance kept in mind while setting up cognos?