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,
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.
Thank you for your reply. I am using the same query.basically its same query/data but diff representation. I would look into Membersets.
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,