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 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.
What are the advantages of using cognos sql?
Can you define drill down and drill up?
-----------------What is Determination Model?
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
Which lifecycle we will use for reporting?
what is stitch query in reportnet?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
How create measures and demensions?
What is the information present in the cognos configuration file?
Define cognos report net?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
what is the main advantage of impromptu over cognos reportnet?
What are all the types of gateway used in Cognos?