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
- 6395 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
WHAT ARE THE DISTNICT VARIABLES?
Define datastores in cognos?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
How to Reset Pagenumbers in one report.
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
Can you define bitmap index?
Can you define materialized view?
Can you define a catalog and types of catalogs in cognos?
How to select multiple values from type-in prompt?
Can you define cognos decision stream?
How can I test reports in cagonos?
----------------Describe DWH Architecture?
Explain the difference between native sql and cognos sql?
Write various indexes used in cognos?
Can you explain the advantage of using shortcuts?
