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,

---

drillthrough vs master detaild report,which one is the best by performance?

3 Answers   IBM,

---

what is the use of lock and unlock

1 Answers  

---

How to move reports one server to another server?

2 Answers   Wipro,

---

-------What are the Adv of Star Schema and Snow Flake Schema?

4 Answers   Bank Of America,

---

---

Can you explain the advantage of using shortcuts?

0 Answers  

---

Whrer u can save the Report net documentation in our local system?

1 Answers  

---

explain project, package ,model , modelers.........and differences b/w them?

4 Answers   HCL,

---

What are the types of folder present in cognos?

0 Answers  

---

what are the tabs in cognos ?

2 Answers  

---

What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.

3 Answers  

---

Give me any example of semi and non additive measures?

0 Answers  

---