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

Tips Recipes Brio 2002

(Creating Read-Only Computed Items continued)

As shown in the previous screen shot, meta-topic computed items can be either server-

based or locally computed. Server items are based on what can be computed via SQL, and

are computed at the database server. Local items can use the full power of Brio’s JavaScript

interpreter, but require all items in the computation to be included on the Request Line. If a

required field is not already present on the Request Line, adding the local computed item

to the Request Line will automatically add all fields needed by the computation.

NOTE: To define a local meta-topic computed item, all columns referenced by the

computed item’s formula must be present in the same meta-topic as the computed

item. You can drag any fields needed from other tables into the meta-topic to

support multi-table computed items. You may want to then hide that field from the

topic in which it normally resides.

5) Once all computed items are defined, use the DataModel | DataModel View | Meta menu

selection to set the display to show only the meta-topics.

6) To make the items read-only, promote the query’s data model to be a Master DataModel by

using the DataModel | Promote to Master DataModel menu selection.

NOTE: To keep the Master DataModel locked for ODS users, deploy the BQY in “Query

and Analyze” mode (not in “DataModel and Analyze” mode).

1 2 ... 11 12 13 14 15 16 17 18 19 20 21 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 16