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

Basic Concepts Brio 2002

• Global Transformations

Global data transformations are a special type of Computed Item. The

same rules apply for global transformations.

Table Sections

The Results section is actually a special, global type of Table section. The new

Table section provides a way to built items that are less global than ones built

within the Results section. It can also be used as a data staging area to enable

various functions not possible before.

Semi-Global Items

A Table section can be used to create semi-global items using the same

techniques used in the Results section to create global items. Items created in a

Table section will only apply to those sections built from that Table section. In

general, sections built using a Table section are isolated from certain changes that

occur in the Results section that feeds the Table section.

Data Staging

The Table section can be useful in those cases where you need to stage the data

for a particular use. For example, you may want to limit which items a user can

drill to but still want to allow Drill Anywhere to work. You can build your chart

or pivot based on a Table section that only contains those columns you want the

user to access. You also might need to create certain complex calculations in

stages. Table sections built from other table Sections can be the answer.

Top N / Bottom N Analysis

Allowing users to easily select how many items to display usually involves

creating a limit. However, Brio will not allow a limit to be created on a

Computed Item based on an aggregate calculation. Rank and Sum are such

aggregate calculations. Enter the Table section. When a Computed Item column

is added to a Table section, it is converted to the actual value derived from the

computation. Since it is now a simple numeric value, a limit can now be applied

to the Rank or Sum value in the Table section.

Report Section Refresh Control

The older v5.x Detail section carried its own version of a data cache specific to

that report. Thus, v5.x documents with multiple Detail sections carried a lot of

redundant data with them. To reduce the size of BQY files that contained

multiple reports, the new Report section is designed to work off the Results or

Table sections. However, since they do not carry their own data cache, Report

sections do not offer any Refresh Control options. You can restore this Detail

section feature by using a Table section as the basis for your Report. You then

create a dummy limit on the Table section to artificially start with zero rows in

the display. When you want to refresh the Report section, simply set the dummy

limit to “Ignore” (either manually or in JavaScript code).

1 2 ... 5 6 7 8 9 10 11 12 13 14 15 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 10