Answer / kumar

1) Try to use the less no. of Queries& Outer Joins.
2) If any calculation are used frequently, that need to do
at ETL level since data will be loaded with taht
Calculation.
3) avoid the Joins at Report Level.
4) Remove the unwanted Columns @ Report level.
5) Adding filters to reduce the amount of data to perform
the report well.
6) if we are using any specific filters for mutiple report
we need to create that filters at FM level as Stand alone
Filters.
7) We prefer Drill through to Master Detail Report to
reduce the time taking.
8) We prefer Conditional block to Render Variable for
Performance.
9) Use Local Cache ,If we run the any Report Frequently it
will reduce the Time.



I added My Experience points,I think few more are thare.


Thank You
Kumar

what is stitch query?

2 Answers   Syntel,

---

pls any body give the cognos 8 versions release year.

3 Answers  

---

What are the types of security?

0 Answers  

---

1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?

1 Answers  

---

..Architectural difference between cognos reportnet and cognos8?

3 Answers  

---

I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?

1 Answers   Cap Gemini, HSBC,

---

How do I remove the hyperlink from the drill through report?

2 Answers   Misys,

---

--------------How to do Report Testing in Reports?

1 Answers   IBM,

---

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

0 Answers  

---

What is the difference between set functions and filter function in dimensional data?

0 Answers  

---

------------------What is Inline Query?

0 Answers   Cap Gemini,

---

How to Create users in cognos Access Manager from 1) front end 2) back end

1 Answers   TCS,

---