If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

dimensional source list report

Started by barrysaab, 24 Mar 2011 04:48:19 AM

Previous topic - Next topic

barrysaab

I have two year of current data in my report,but the data is coming as one year below another(please see my attachment).I want it to be as

2004  2005
a b c   a b c

How could it be done.please help.Thanks
Boy! Cognos getting on to me!!!

bvk.cognoise

#1
Hi,
we can achieve this requirement using join query,may be there is a diffrent process but i know this process only.

1st step:
>create a blank report
>then go to query explorer
>drag a join quer from insertable objects pane
>quer one will generate
>then drag two new querys into join query drop down place
>quer2 and query3 will generated


2nd step:
> then add data items items into query2 by double clicking on the quer2
for eg i used:  Productline ,year,revenue
>now drag year data item into detailed filter
>give filter like year='2005'
>then rename revenue data item as '2005 revenue' in properties pane

3rd step:
>next add new daat items into query3
for eg:productline,order year,revenue
>now drag year data item into detailed filter
>give filter like year='2006'
>then rename revenue data item as '2006 revenue' in properties pane

4th step:
>then double click on join symbole in query explorer
>join relation ship screen will displays
>give relation between Query2 Product line and Query3 Product line
>check relation according to requirement

5th step:
>now click on joine quer means Quer1
>add data items from query2 and query3
>here we have to add only Productline,2005 revenue,2006 revenue to Query1

6thstep:
>then go to report page1
>there add a list report to that page
>select entire report using ansistor
>assign qury1 to that list using quer properties in properties panel

7th step:
>simply add data items from query1 to report
eg:Product line,2005 revenue,2006 revenue


its easy............please find the attachment hope it helps u alot   ;)


Regards
BVK

barrysaab

Thanks Vamsi.My source is dimensional and the year to select is dynamic for ex if user select 2008, he should also get data of previous year 2007.Thanks for your help.
Boy! Cognos getting on to me!!!