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 |
APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
How applying "Level Span" in Cognos 8.3?
wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container
----------------Diff b/w Dimensional modeling and Relational modeling?
Hi, I am Searching on Cognos 8, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is balajishriram@gmail.com. Hope you will help....
What is cognos connection?
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
Diff b/w Crossproduct and Outerjoin?
What is defined as Cognos Impromptu?
Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?
1.tyes of security in cognos?.how to use rank function? 2.what is content store? 3.what is content manager? 4.how 2 use rank function?