Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Drill Down Behaviour Question

Status
Not open for further replies.
Revelator80

Revelator80

Technical User
Jul 14, 2010
14
GB
Hi,

I have a list report based on DMR which has two columns for Category and Customer Sector with spend and target information data shown. The category and customer information is hierarchical and I have enabled drill up/down on the report. What I need is the ability to specify that when a sector is selected, only the category that you have clicked from is brought back on the drill (e.g. Health exists in both IT and Finance categories, if I click the Health sector in Finance I only want to see the next level down for Finance).

Any suggestions?
 
Status
Not open for further replies.

Similar threads

sreevp2020
  • Locked
  • Question
Cross tab intersection drill through
Replies
0
Views
141
sreevp2020
sreevp2020
goice
  • Locked
  • Question
Report 10.1.2 Drill Through Problem from Report Author (OLAP) to Report Author (Relational)
Replies
0
Views
54
goice
goice
Starfish2201
  • Locked
  • Question
Drill-down in Excel sheet as Cognos output
Replies
1
Views
35
blom0344
blom0344
Wolfy11
  • Locked
  • Question
Drill Through from Cross Tab to List with Static/Hardcoded Parameter
Replies
3
Views
158
Wolfy11
Wolfy11
Sidney786
  • Locked
  • Question
Cognos 7.1 Drill?
Replies
0
Views
38
Sidney786
Sidney786

Part and Inventory Search

Sponsor

Back
Top