Drill up and drill down works, but in your case if it is not working then check following things.
1) Data Menu > Drill Behaviour > Enable Drill up and Down check box is checked !!!!
2) You have not played with the dataitem on which you have to drill because DRILLING is very sensitive and it is totally handled by Framework Manager.If you do something in that dataitem like doing some calculation or using CASE_WHEN , drilling behaviour will be gone.
Even after having above 2 points ok,still the DRILL is not working ???
That means your query is very complex and Cognos is forgetting that it has to drill on that particular dataitem.
Do one thing go in the query and create a Member Set on that data item and define advanced drill behaviour on that dataitem so as to make cognos remember its drill property after the report is run.
Thanks
Vishwas
No comments:
Post a Comment