Answer / kumar

1. check the governor settings.

2.Avoid using 'NOT' function in the query

3.Avoid using more no:of filters, complex calculations and
complex reports.

4.Move all the calculations and filter conditions from
report level to FM level.

5.Check the client server balancing

6. check the table qualifying and weighting

Answer / venkat m

turn of automatic summaraize and group for tabular model
processing database it is more faster than limited local process
write simple case statemants
set sorting a field either at the tabular model level or
query level but not both
use cognos functions equivalent functions in database
use facts in the report directly donot create shortcurts for
facts under query
use page breaks instead of sectioned

Answer / arkchowdary

-----------Improve the performance of the Report-----------

By GovernerSettings we will improve the performance.

By reducing the filters and by reducing the joins.
making the report more simple can improve the performance
of the report

Answer / g

By reducing the filters and by reducing the joins.
making the report more simple can improve the performance
of the report

How can you create prompts in framework manager?

4 Answers   Tech Mahindra,

---

what is the role of cognos comsultant?what actually it means?pls reply

0 Answers  

---

what is #prompt and #promptmany, runningtotal in report studio

1 Answers  

---

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this

2 Answers  

---

In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha

0 Answers   TCS,

---

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error

0 Answers   IBM,

---

Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?

1 Answers   HSBC,

---

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

0 Answers  

---

how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please

6 Answers   TCS,

---

------------- How to identify the Revenue Column in Report?

0 Answers  

---

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!

5 Answers   HCL, Wipro,

---

How do you deployment reports from one server (Development) to other server(Production)? How do you configure the cognos7.0 version cube in cognos 8.0? Pls, explain with example? How do you create IQD without IMR or can u explain other way create IQD?

2 Answers   TCS,

---