
Tips Recipes Brio 2002
Copyright © 2002, Brio Software Page 19
(Creating Incremental Drilling continued)
3) To remove a topic item from the drill path (such as items that are facts, not dimensions),
click on the topic item. Right-click on the item and select “Properties” from the speed
menu. Turn on the “Set as Fact” checkbox.
4) In the menu system, select DataModel | DataModel Options to display the Data Model
Options dialog. On the General tab, turn on the “Drill to Detail” checkbox.
5) Create your top-level chart as usual. When a user double-clicks on a bar in the chart, Brio
will ask if the user wants to add the missing dimension to the query, and then if the user
will allow it to copy the query and chart definition to new sections to preserve the original.
Answer “yes” to both questions. (You can avoid the dialog box questions in the future by
checking the “Don’t show this warning again” checkbox in the dialogs the first time.)
6) Brio will copy the query and chart sections, but with a new dimension on the query’s
Request line and a new limit based on the bar the user double-clicked on. Now, keep
double-clicking on a target bar and Brio will continue to add new dimensions and limits,
and then automatically re-process the query as needed to perform the drilling.
Comentarios a estos manuales