Interested to Buy Any Domain ? << Click Here >> for more details...
How can I disable the drill-down for the last level of my
dimensional hierarchy ????
- 1 Answers
- 9522 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 |
Can u please describe the different types of traps with eg. Thanks
What is the difference between low affinity and high affinity connections?
how you migrate reports to cognos 8 from previous versions?
What are the types of catalogs in cognos?
Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar
Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?
how u will design the report if the objects are available
Can you define metrics designer?
How to move reports one server to another server?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
3 Answers TCS, Thomson Reuters,
What is slowely changing dimensions?why we are used SCD?
Teradata 
