Component Solution Services REC02F Manual de usuario descargar pdf (Pagina 34)

Tips Recipes Brio 2002

Section Type: Table section

Tip Name: Hiding columns from a Pivot or Chart

Purpose / Use: In some applications, you need to fetch more columns than you want

users to be able to drill into with Drill Anywhere. Hiding a column in the

Results section doesn’t hide it from the drill path of a pivot or chart.

Sample File: Hiding columns in a pivot.bqy

Steps to Produce: Create a Table section with the items you want users to drill into, then

build your pivot or chart from the Table instead of the Results section.

(Works with all v6.x versions of Brio Intelligence.)

1) Build your query as normal and process it to fetch some initial data.

2) With the Results section selected, insert a new Table section.

3) Drag into the Table design only those fields you want to use as either part of your initial

charts and pivots, or as items available for drilling.

4) With the Table section selected, insert a new chart or pivot. This sequence ensures that your

chart or pivot will be built based on the Table section, not the base Results section.

1 2 ... 29 30 31 32 33 34 35 36 37 38 39 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 34