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

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

1 Answers
6601 Views
IBM, I also Faced
E-Mail Answers

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

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!

5 Answers HCL, Wipro,

What is main difference mapplets and mapping?

0 Answers

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?

4 Answers Tech Mahindra,

What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

2 Answers

What is the difference between cognos 8.2 and cognos 8.3?

5 Answers

how to handle multifact?

2 Answers IBM,

Define olap designer?

0 Answers

What is Conditional block? How do you use in a report?

1 Answers IBM,

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??