Answer / suresh

Model Filter: need to create a filter inside the FM model
itself.
(Stand Alone or Embeded)
Query Filter: Need to create in RS query.

Answer / kumar

Hi Friends,

We have Filters @ FM Level, Reprt Level

1) FM Level:
a) Stand Alone Filters, We prefer these kind of
Filters whenever we want to use filter for entire Package.
b) Embedded Filters, We prefer these kind of Filters
whenever we want to use filter for Particular Query Subject.

2) Report Level:

a) Summarized Filters are used to filter the group of
records ( Like Having clause in Oracle).( After the
Aggregation)
b) Detail Filters are used to filter the indivisual
records ( Like Where clause in Oracle) (before the
Aggregation)

&

We have Static Filters , Dynamic Filters @ Report Level.

In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.

4 Answers   Accenture, HCL, IBM,

---

1. Explain your project.

0 Answers   IBM,

---

What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,

2 Answers  

---

How we check the errors before running the report?

0 Answers  

---

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

0 Answers   IBM,

---

Can i apply drill through on master detail relationship report?

2 Answers   TCS,

---

What is dtm?

0 Answers  

---

What is Parametermap?

2 Answers  

---

how to access the database directly from cognos reportnet

2 Answers  

---

write a query to display the third record from the employee table?

4 Answers   HCL,

---

we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....

1 Answers   IBM,

---

what is the difference between querystudio in reportnet and cognos8

0 Answers   CTS,

---