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
- 9684 Views
- I also Faced
- E-Mail Answers
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 catalog and types of catalogs in cagnos and which is better?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
How can we create a dynamic column name in cognos?
Can you explain model durability?
Can you define fan trap?
faq's on cognos
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is the report studio?
Explain the different types of views used in cognos.
is there any difference between operational database and data base?if yes what r they?
how to create measures and dimensions?
What are the advantages of cognos?
-----------Diff b/w OLAP and RDBMS?
How can create users and permissions in cognos?
