---------------How to identify First Record and Last Record?

2 Answers  

---

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,

---

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

0 Answers  

---

Mention the difference between ‘macros’ and ‘prompt’?

0 Answers  

---

Sales person are there in one company How to do Bursting on this particular requirement?

0 Answers  

---

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

0 Answers  

---

Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated

1 Answers   IBM,

---

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,

---

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

0 Answers  

---

Any Cognos planning Queries Rise

5 Answers  

---

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

0 Answers  

---

what is the difference between querystudio in reportnet and cognos8

0 Answers   CTS,

---