what is the difference b/w mdx and sql?
Answer Posted / surendra
By using mdx we can retrieve the data from the analysis service where as sql retrieve the data from relational database.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the different uses of a repository manager?
Explain the difference between native sql and cognos sql?
How can create users and permissions in cognos?
What are the message flows?
What is the report studio?
is there any difference between operational database and data base?if yes what r they?
What are the other methods working as deployment functionality?
i have one file i saved in csv how can i take these file into framework manager
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
tell me two or three issues from client side and how to solve those issues?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
how to connect datamarts
9. What was the most complex type of report you dealt with?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!