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 was the actual purpose of portfolio in cognos ?

1 Answers  

---

Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.

3 Answers   iGate,

---

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,

---

-----------Types of Fact Tables?

6 Answers   Bank Of America, CTS,

---

1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com

1 Answers   IBM,

---

What do you understand by the term 'aggregate cache'?

0 Answers  

---

what are the enhancements in cognos reportnet ?

9 Answers   IBM, TCS,

---

Difference between Express authoring mode and Professional authoring mode?

2 Answers   Wipro,

---

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

0 Answers  

---

what is mean of Meta data definistions?

4 Answers   IBM,

---

hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.

0 Answers  

---