Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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....

Question Posted / seasikumar


we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab wi..

Answer / 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

More Cognos Interview Questions

Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...

1 Answers  

what is the difference between a data item and a query item?

2 Answers   Bodhtree, HP,

fiscal year means what???

8 Answers   iFlex, iGate,

How do you call a store procedure within a transformation?

0 Answers  

i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..

0 Answers  

can we insert list report in corsstab report?

1 Answers   JPMorgan Chase,

what is the difference between aggregation and role up aggregation ?

1 Answers   Systime,

How to join multiple db in catalog?

0 Answers  

Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?

7 Answers   Cognizant, Cognos,

What is Merging, Segments and porting in Framwork Manager?

3 Answers   Nike,

What is Dynamic Grouping? what is diff between grouping n levelspan?

2 Answers   CybAge,

what is an associated query?

2 Answers  

For more Cognos Interview Questions Click Here
Categories