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.

faq's on cognos

0 Answers  

---

how to convert crosstab into list?

4 Answers   TCS,

---

How to move reports one server to another server?

2 Answers   Wipro,

---

What is metric store database?

0 Answers  

---

What is a Cube?

0 Answers  

---

My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.

1 Answers  

---

Explain the difference between native sql and cognos sql?

0 Answers  

---

What are the Macros?

3 Answers  

---

What are the types of security?

0 Answers  

---

what is slowly growing dimension??

6 Answers   Accenture,

---

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,

---

what is requery in cognos?

0 Answers   HMN, Satyam, TCS,

---