How can I disable the drill-down for the last level of my
dimensional hierarchy ????
Answer / 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 |
What is the difference between a cascading report and drill through the report?
What is the difference between low affinity and high affinity connections?
How to Improve the Performance of the Report? i need this urgently .
-------------What is Coditional Prompting?
Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...
----------------What is meant by DSS?
what are the tabs in cognos ?
What is the importance of Dimension in the cognos.
Explain the difference between powerplay transformer and power play reports?
how to find the rank in report studio? i need steps for this question.
plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?
What is catalog and types of catalogs in cagonos and which is better?