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

Give me any example of semi and non additive measures?

0 Answers  

What is meant by Tabular SQL in Cognos Report net

3 Answers   Infosys,

if there are list,crosstab,chart how can you apply a single filter to all object?

3 Answers   IBM, Syntel,

Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480

7 Answers  

How to Improve the Performance of the Report? i need this urgently .

4 Answers   HSBC,

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

0 Answers  

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

2 Answers   IBM,

----------How to cretae a Template?

4 Answers  

what use of surgate key in project

3 Answers   HCL, TCS,

Can you define dimension?

0 Answers  

Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

0 Answers   IBM,

How applying "Level Span" in Cognos 8.3?

1 Answers  

For more Cognos Interview Questions Click Here
Categories