Framework:BI Center:Formula Editor

Just in work

Use the Formula Editor to write CoPlanner expressions for masks and CoPlanner Cube item properties. You can use expressions to set many properties, including filter properites, captions, tooltips and special. At run time, the CoPlanner processor evaluates expressions and substitutes the result for the value of the property.

Expressions can be simple or complex. You can type simple expressions directly in a text box on the design surface or in a dialog box. To create complex expressions, use the Formula Editor.

To open the Formula Editor, click the Expression button in properties.

Error creating thumbnail: File missing

BI-Center, Formula Editor

The Formula Editor includes a code window, category tree, category items and description pane.

The Formula Editor is context-sensitive. The category items and descriptions change in response to the expression category you are working with. It supports syntax coloring to help you detect syntax errors.

Options of Formula Editor

Code window

Use the code window in the top pane to type an expression. When you open the Formula Editor, the code window contains the expression. You can replace or revise the expression. You can add function calls, operators, constants, fields, parameters and application properties.

Category

Displays categories of expressions. Choosing a category establishes a context for creating an expression and changes the list of valid values in the Item pane.

Item

Zeigt eine Liste gültiger Werte zur ausgewählten Kategorie.

Beschreibung

Displays the list of valid values for the selected category.Double-click on an item to add the expression text for this item at the insertion point in the code window.

Evaluate

This is an optional button. Is opens the Evaluate Dialog box. You can insert values for all parameters and it desplays the result.

Expression Constructs

Choosing a category establishes a context for creating an expression and changes the list of valid values in the Item pane.

Application Properties

The application properties are used to store reference values for calculations or processes in CoPlanner.

Client-side functions

Client-side functions are to display data in masks. They are used for dynamic column header, filter captions, tooltips, etc. You can use these functions in input masks, analysis views or row views.

Dimensions

A list of all dimensions and dimension attributes in the mask.

Imports

A list of all imports in the application.

Macros

A list of all macros in the application.

Measures

A list of all measures in the mask.

Serverseitige Funktionen

Die serverseitige Funktionen bieten Zugriff auf alle Session-Variablen, Anwendungseigenschaften und den gesamten Datenbestand. Session-Variablen und Anwendungseigenschaften werden mit '@' qualifiziert, serverseitige Funktionen mittels FKT*. Sobald eine Formel '@' oder FKT enthält wird diese vom Client an den Server gesendet und dort verarbeitet.

Sessionvariable

Sessionvariable sind sitzungsspezifische Eigenschaften, d.h. vom Unternehmen, Szenario und Zeit abhängig.

Siehe auch

Grundlegendes zu Ausdrücken
Angeben eines Ausdrucks
Verwenden von Ausdrücken