Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Analytics Server Administration Guide > Administration Tool Utilities and Expression Builder > Expression BuilderYou can use the Expression Builder dialog boxes in the Administration Tool to create constraints, aggregations, and other definitions within a repository. The expressions you create with the expression builder are similar to expressions created with SQL. Except where noted, you can use all expressions constructed with the expression builder in SQL queries against the Siebel Analytics Server. For information about using SQL with the expression builder, see SQL Syntax and Semantics. For information about the SQL functions supported by the Siebel Analytics Server, see SQL Reference. This section includes the following topics:
About the Expression Builder Dialog BoxesYou can access the expression builder from the following dialog boxes:
Figure 21 shows an example of an expression builder. The edit pane at the top of the dialog box allows you to edit the current expression. In the lower half of the dialog box, the left pane is the Selection pane. It displays the folders that are appropriate for the dialog box from which you accessed the expression builder. The middle pane is the Categories pane. It displays the available categories for the folder you select in the Selection pane. The right pane is the Building Blocks pane. It displays the individual building blocks for the category you select in the Category pane. The toolbar in the middle contains commonly used expression building blocks. Expression Builder ToolbarThe toolbar is located in the middle portion of the expression builder. Table 24 describes each icon and its function in an expression. Folders in the Selection PaneThe folders that appear in the Selection pane vary based on the dialog box from which you accessed the expression builder. This section describes the folders that may appear. Aggregate ContentThe Aggregate Content folder contains the available aggregate functions. Aggregate sources must use one of the functions listed here to specify the level of their content. DimensionsThe Dimensions folder contains the dimension configured in the business model. If no dimension exists in a business model, or if the dimension folder is not pertinent to a particular expression builder, the Dimension folder is not displayed. When you select the Dimensions folder, each configured dimension displays in the middle pane, and each level for the selected dimension displays in the right pane. Logical TablesThe Logical Tables folder contains the logical tables configured in the business model. If logical tables are not pertinent to a particular expression builder, the Logical Tables folder is not displayed. When you select the Logical Tables folder, each logical table in the business model displays in the middle pane, and each column for the selected logical table displays in the right pane. OperatorsThe Operators folder contains the available SQL logical operators. ExpressionsThe Expressions folder contains the available expressions. FunctionsThe Functions folder contains the available functions. The functions that appear depend on the object you selected. ConstantsThe Constants folder contains the available constants. TypesThe Types folder contains the available data types. Repository VariablesThis folder contains the available repository variables. If no repository variables are defined, this folder does not appear. Session VariablesThis folder contains the available system session and non system session variables. If no session variables are defined, this folder does not appear. Example of Setting Up an ExpressionFigure 22 shows the expression builder for a derived logical column, with a blank expression. With the Functions folder selected in the left pane, double-clicking on the function in the right pane pastes the function in the expression builder's edit box. Clicking once between the parentheses of the function darkens that area, marking it as the insertion point. Double-clicking on the logical column pastes the logical column into the insertion point as the argument of the function. Figure 23 shows where the expression appears in the window. Navigating Within the Expression BuilderUse the following procedure to navigate within an Expression Builder dialog box. To navigate within an Expression Builder
Building an ExpressionUse this procedure to this procedure to build an expression in the Expression Builder dialog box.
|
![]() |
![]() ![]() |
Siebel Analytics Server Administration Guide |