Pre-defined conditions @ L.V. Expertise X3

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

The pre-defined conditions can be of two types:

either simple conditions, that involve fields and possibly constants.
or conditions involving setup values previously entered (these conditions are called prompts).

the pre-defined conditions entry screen is set on a single tab, but there are quick select lists that are used to view:

the datamart conditions via a first list organized in a tree structure, and then in a fact table.
and via a second list, the conditions in a global fashion.
via a third list, the prompts.

Entering a pre-defined condition is carried out on a datamart and on a given fact table.

In the section displaying the objects of the universe which reports are currently being created, the pre-defined conditions are displayed after the dimensions and the information. In order to display a pre-defined condition in the tree structure of a dimension, it is necessary to enter the dimension in the corresponding field.

If a pre-defined condition is not a prompt, it is defined as a SQL query (either independent from the database, or defined differently for each database).

However, if it is a prompt, this expression should be defined as an SQL query that includes variables instead of constants, and that sets conditions on the database fields. In order to display these variables, which title depends on the generation language, it is possible to pick one or two objects from the BO universe, which determines the database fields that concerns the conditions (#fld1, #fld2), as well as an associated selection(#obj1,#obj2).

A variable entered when launching a Business object report is defined by the following syntax:

@prompt('#txt1','D','#obj1',Mono,Constrained,Persistent,,)

The correspondences are the following:

The #txt1 fields corresponds to the text displayed to the user during the entry (this is the Prompt text field entered in the screen).
The #obj1 Field corresponds to a selection list depending on the selected criterion.

If an equality criterion should be defined on the field, the following will be entered:

#fld1 = @prompt('#txt1','D','#obj1',Mono,Constrained,Persistent,,)

Entry screen

Presentation

All the characteristics used to define the condition are entered in this screen.

Fields

The following fields are present on this tab :

Block number 1

Code (field COD)

Order (field ORD)

Title (field ZDES)

Evaluated title (field INTEVAL)

Characteristics

Datamart (field ABM)

Activity code (field ACV)

Module (field MODULE)

Setup

Fact table (field CODABF)

Dimension (field CODLNK)

field EXPLNK

Prompt text (#txt1) (field ZTEX)

Object 1 (#obj1) (field OBJ1)

Field 1 (#fld1) (field CHP1)

Object 2 (#obj2) (field OBJ2)

Field 2 (#fld2) (field CHP2)

Default condition (field CNDDEF)

Oracle condition (field CNDORA)

Sql-server condition (field CNDSQL)

Specific Buttons

The following fields are present on the window opened through this button :

Block number 1

field OBJET

field CLES

Block number 2

From folder (field DOSORG)

This field is used to define the folder from which the record is going be copied. The possible syntaxes are described in the dedicated appendix.

All folders (field TOUDOS)

This option is used to copy the record to all the folders defined in the dictionary (ADOSSIER table from the current solution).

To folder (field DOSDES)

This field used to define the folder in which the record is going be copied. The possible syntaxes are described in the dedicated appendix.

This button is used to copy the record definition from or to another folder.

Generic messages

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation