Framework:Fundamentals of Expressions: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
(Just in work) | (Just in work) | ||
Use expressions in CoPlanner Cubes, masks or views to calculate, display, filter, | Use expressions in CoPlanner Cubes, masks or views to calculate, display, filter, parameterize or format data. Many mask item properties can be set to an expression. Expressions help you control the content, design, and interactivity of your mask. Expressions are written in CoPlanner notation and evaluated by the CoPlanner server or CoPlanner client. | ||
The CoPlanner notation differs according to be evaluated by the CoPlanner server or CoPlanner client. | The CoPlanner notation differs according to be evaluated by the CoPlanner server or CoPlanner client. | ||
| Line 30: | Line 30: | ||
| '''Functions''' | | '''Functions''' | ||
| Server | | Server | ||
| Server-side functions:FKT_functions and application properties. Session variable??? | | Server-side functions: FKT_functions and application properties. Session variable??? | ||
| <span {{CoPFormel}}>FKT_TimeDimAdd(Y,-1, [bsp_tbl_Periodfunctions.dim_sys_zeit_1.COPSYS_ID])</span> | | <span {{CoPFormel}}>FKT_TimeDimAdd(Y,-1, [bsp_tbl_Periodfunctions.dim_sys_zeit_1.COPSYS_ID])</span> | ||
|- | |- | ||
Revision as of 14:11, 25 April 2012
(Just in work)
Use expressions in CoPlanner Cubes, masks or views to calculate, display, filter, parameterize or format data. Many mask item properties can be set to an expression. Expressions help you control the content, design, and interactivity of your mask. Expressions are written in CoPlanner notation and evaluated by the CoPlanner server or CoPlanner client.
The CoPlanner notation differs according to be evaluated by the CoPlanner server or CoPlanner client.
| Expression | Evaluation | Description | Example |
| Measure | Server or client | Measures always (client- and server-side) qualify with square bracket. | [Quantity] |
| Filter/Axis | Server | Filter and axis qualify with 'Attribute'-function. | Attribute(Period) Attribute(Products.vs_key) Attribute(Profit Center/Cost Center.Level) |
| Filter/Axis | Client | Filter and axis qualify with square bracket. | [Period.ID] [Products.vs_key] [Profit Center/Cost Center.Level] |
| Functions | Server | Server-side functions: FKT_functions and application properties. Session variable??? | FKT_TimeDimAdd(Y,-1, [bsp_tbl_Periodfunctions.dim_sys_zeit_1.COPSYS_ID]) |
| Functions | Client | Client-side functions: Functions and application properties. Session variables??? | TimeDimAdd(M,-12,[Period.ID]) |
Siehe auch
Angeben eines Ausdrucks
Formeleditor
Verwenden von Ausdrücken
