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....
I have a reports on cognos ep7series version3 with database
SQl2000.Now i am migrating database SQL2000 to SQL2005.Then
What happens to cognos reports and also there is reports
cubes then how can i handle this problem please give me
step by step solution b'coz i am new to cognos ep7series
can anyone provide link to download cognos 7.2 version for
download along wiht installation and configuration steps tx
in advance
32
I have 7500 rows. I need all rows in single reports. Which
type of prompt we have used retrieving all rows and show in
a report?
We have dynamical queries q1, q2, q3, q4, q5. If customer
selects the particular, query that only show in execution
report. In case it may more then one, how do you execute the
particular query item in report page?
What are the difference bt OLDP and OLAP?
my report ended at the half of the last page but i don't
want that matter in the last page I would like to adjust the
matter in the previous page .how can i do this?