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

What do you understand by the term 'aggregate advisor?'

0 Answers  

What is Outerjoin?

2 Answers  

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

0 Answers   Infosys,

Explain about embedded & standalone filters?difference between them

1 Answers  

What is the report studio?

0 Answers  

In an existiing Framework model, how will you add a new column to the existing table?

6 Answers   CTS,

What is portal page?

5 Answers   TCS,

Define query items?

0 Answers  

how many types of keys are there i.e primary key and foreign key etc..?

3 Answers   IBM,

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

2 Answers   iFlex,

plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?

2 Answers  

how can you get the errors in job? when loops are araised we get error?

0 Answers   Syntel,

For more Cognos Interview Questions Click Here
Categories