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

Crosstab/Chart drill up/down Sync Using DMR

Started by biworld, 26 Jul 2012 02:53:42 PM

Previous topic - Next topic

biworld

hi Friends,

I have a crosstab and its chart Representation. As using DMR Modeling and having drill down/up enabled, User can drill up and down on crosstab and chart needs to reflect same level (both are using same query).

Requirement is :I have data for 4 years,(2012,2011,2010,2009). when I drill down on crosstab for particular Year (say 2011) I should

see all the twelve months for year 2011 and its corresponding values. I should not see other years on either crosstab or chart.

Crosstab gives me this results, but chart when drilled down gives month level number for all four year(2012 Jan to Dec, 2011 Jan to Dev ..till 2009).  which makes it out of sync with Crosstab and also very messy look as it tries to fit in so much data in small place.

Required Solution: is there a way to limit data displayed in Chart to the Year Drill down??

It should be a simple thing and I am sure cognos should be able to achieve it pretty easily.

Thanks,

rockytopmark

Are you using same query for both objects?  If not, I would suggest you do.  Also, if a different item from the Date Dim is used in the Crosstab and Chart, I can see the need for some Member Set definitions, to "link" the different items from Date Dim.

biworld

Thank you for your reply. I am using the same query.basically its same query/data but diff representation. I would look into Membersets.

biworld

Actually I am not using diff item from dim time. Its both same query,same data items.??

Do you see any other reasons/things I should consider?

Thank you,