Framework:Fundamentals of Expressions

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])

See also

Specify an Expression
Formula Editor
Expression Uses in CoPlanner