Basic Concepts Brio 2002
Copyright © 2002, Brio Software Page 7
Why do you need a Table section? To code how many items get displayed, you
need to be able to set a limit on the Rank. However, Brio doesn’t let you create a
limit on a column based on an aggregate function. The Table section let’s you
convert that aggregate column into a plain numeric one. Thus, the Table section
will be required to create a limit on the rank. It’s the only way to provide
programmatic control of how many of the top items get displayed.
Prepare Your Data
As was mentioned before, you will probably need to craft your data in some way
before building your charts and pivots. You need to select which data crafting
operations you will perform in which of three possible section types – the Query
section, the Results section and (occasionally) one or more Table sections. Each
type of section is appropriate for performing different types of data crafting
tasks.
The Query Section
The query section is where you create the basis for all drilling options. It is also
the place where you should create your first level of aggregation of the data for
summary analysis charts and pivots. Having the database perform much of the
data aggregation will improve performance greatly. Server-based computed
items are also defined here, as is special data retrieval query logic.
The Results Section
This is the section where you create your global items. Anything that you want to
use in multiple sections should be created either here or in the query section that
feeds it. These global items fall into several categories:
• Default Labels
The column labels that appear in the Results section will be the default
labels for all charts, pivots and reports built from this data. You can set
these global default labels in either the Query or Results section.
• Default Formats
Like column labels, the display format used in the Results section will be
the default formatting for all charts, pivots and reports built from this
data. These global default formats can only be set in the Results section.
• Global Computed Items
Computed Items that need to appear in more than one section should be
defined here in the Results section.
• Global Comparisons
Like global computed items, comparisons that need to apply across
multiple sections should be defined once in the Results section.
• Global Groupings
Groupings that apply across multiple sections are just like other global
items. They should be defined in the Results section.
(142 paginas)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales