Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the performance of the report at the report
level?
- 3 Answers
- 5436 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkat
Remove the unwanted joins and filters
and complex calculations we will do the all calculations in
the item level in Framework manager level
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
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...
How the Bursting happens in same report and how to Print the bursting Report?
What are the types of security?
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 ?
What is defined as data mining?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Can you define cognos decision stream?
Define query studio?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What is catalog and types of catalogs in cagonos and which is better?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
Can you define framework manager?
