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
- 6513 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 to test reports in cognos?
Can you define cognos decision stream?
What are shortcuts? Where it can be used? What are the advantages?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What are all the types of gateway used in Cognos?
What is zero-foot print?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
is cognos 7 is better than cognos 8
How to test a cube?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What are the roles defined by cognos platform?
what are the names of the reports that you prepared?
What is a Transformer?
------------- How to identify the Revenue Column in Report?
