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....
IBM,
1 5718
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
Give the advantages of cognos?
Why need staging area database for dwh?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
Mention the difference between ‘macros’ and ‘prompt’?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
How create measures and demensions?
What are query items?
how to create measures and dimensions?
What are the considerations regarding performance kept in mind while setting up cognos?
Can you define a query subject?
9. What was the most complex type of report you dealt with?
Can you define snapshot?
How is cognos model organization works?
