Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6599 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / s sri harsha mediboyina
We can achieve the same using List rather than going for
Crosstab.Create two data items like
Feb08:
if([Date]>=_first_of_month(2008-02-28)
and [Date]<(2008-02-28))
then([Loan Amount])
else(0)
and
Feb07:
if([Date]>=_first_of_month(2007-02-28)
and [Date]<(2007-02-28))
then([Loan Amount])
else(0)
Then place Data ,Feb08 and Feb07 columns in a list and that
will do the samething as crosstab does.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
Can you define cognos impromptu?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
how can you get the errors in job? when loops are araised we get error?
What is catalog and types of catalogs in cagonos and which is better?
------------ Diff b/w MemberCaption and MemberDescription?
-------------How you design DWH?
What is the difference between a data mart and a data warehouse?
what is the difference between list report and crosstab report?
What is defined as Query studio?
How we check the errors before running the report?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
what are the dimensions that you have in your current project?list them?
