Framework:Fundamentals of Expressions: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 20: | Line 20: | ||
| '''Filter/Axis''' | | '''Filter/Axis''' | ||
| Server | | Server | ||
| Filter | | Filter and axis qualify with 'Attribute'-function. | ||
| <span {{CoPFormel}}>Attribute( | | <span {{CoPFormel}}>Attribute(Period)<br>Attribute(Products.vs_key)<br>Attribute(Profit Center/Cost Center.Level)</span> | ||
|- | |- | ||
| '''Filter/Axis''' | | '''Filter/Axis''' | ||
| Client | | Client | ||
| Filter | | Filter and axis qualify with square bracket. | ||
| <span {{CoPFormel}}>[ | | <span {{CoPFormel}}>[Period.ID]<br>[Products.vs_key]<br>[Profit Center/Cost Center.Level]</span><br> | ||
|- | |- | ||
| '''Functions''' | | '''Functions''' | ||
| Server | | Server | ||
| | | Server-side functions:FKT_functions and application properties. Session variable??? | ||
| <span {{CoPFormel}}>FKT_TimeDimAdd(Y,-1, [ | | <span {{CoPFormel}}>FKT_TimeDimAdd(Y,-1, [bsp_tbl_Periodfunctions.dim_sys_zeit_1.COPSYS_ID])</span> | ||
|- | |- | ||
| '''Functions''' | | '''Functions''' | ||
| Client | | Client | ||
| | | Client-side functions: Functions and application properties. Session variables??? | ||
| <span {{CoPFormel}}>TimeDimAdd(M,-12,[ | | <span {{CoPFormel}}>TimeDimAdd(M,-12,[Period.ID])</span> | ||
|} | |} | ||
Revision as of 14:10, 25 April 2012
(Just in work)
Use expressions in CoPlanner Cubes, masks or views to calculate, display, filter, parameterise 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
