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
- 6482 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
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
Which lifecycle we will use for reporting?
What is called materialized view?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What are the two types of framework manager?
Can you define transformer?
What are the types of catalogs in cognos?
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
Can you define fan trap?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
What are the services provided in cognos 8?
what is stitch query in reportnet?
What are the types of folder present in cognos?
How can create users and permissions in cognos?
-----------Diff b/w OLAP and RDBMS?
