How can I disable the drill-down for the last level of my
dimensional hierarchy ????
Answer Posted / douglas wallace
I cut this from the book and it pertains to a dimensional
chart, but it should also apply to a crosstab or list also.
You could also "probably" apply security to level.
1. Open a chart that uses a dimensionally modeled data source.
2. From the Data menu, select Drill Behavior.
3. On the Basic tab, in the Report Drill Capabilities,
select the Allow drill up and down check
box.
By default, the system determines which items can be drilled
on, based on the dimensional
structure.
On the Basic tab, you can make drilling unavailable for any
data item by selecting the
parameter in either the Disable drill up for box or the
Disable drill down for box.
On the Advanced tab, you can change the drill-up or
drill-down behavior for any parameter
by selecting the parameter and then choosing one of the
desired behaviors.
4. Click OK.
The chart generates links for any item that can be drilled
down on.
You can drill down or drill up by right clicking and
choosing the action from the context menu.
The menu items are unavailable if an item cannot be drilled
up or down on.
| Is This Answer Correct ? | 1 Yes | 15 No |
Post New Answer View All Answers
------------------What is Inline Query?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate i'm searching on cognos..i want to know real time
scenarios..persons having real time exp or undertaking
trainings or who searching on cognos...can send me the
details...for proper guidence..for project and interview
preparation..pls help me out..my mail-id is
ammu2india@gmail.com..hope u will respond as soon as
possible..thanks.. What do you mean by drill through report? hi all i am searching for cognos jobs pls inform about the
jobs to:santosh.koora@gmail.com What are all the components of Report Studio? What are the advantages of shortcuts? how do you deploy a report in cognos 8 to run in maximo6?
what r the steps in maximo?? Define report item? --------------Diff b/w ODS and OLAP? how to perform back drill through in cognos 8 what is the
use of it Can you define drill down and drill up? What is the difference between group and associare? What are various types of gateways in cognos? how can I test reports in cagnos?