How can I disable the drill-down for the last level of my
dimensional hierarchy ????
- 1 Answers
- 9160 Views
- I also Faced
- E-Mail Answers
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 are the names of the reports that you prepared?
what is logs in cognos
Can you define dimension?
What is the enterprise class platform architecture of cognos 8?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
write a query to display the departments with no employee?
What are the differences between Cognos 8 and Cognos 7.x version?
why we r using report studio in webbased only and fm windows based only
How to hide the prompts
Write various indexes used in cognos?
what is exact catalog size?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
Teradata 
