Framework:Fundamentals of Expressions: Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
← Older edit
VisualWikitext
No edit summary
No edit summary
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
(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.
 
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.
The CoPlanner notation differs according to be evaluated by the CoPlanner server or CoPlanner client.
Line 14: Line 12:
|-
|-
| '''Measure'''
| '''Measure'''
| Server oder Client
| Server or client
| Measures werden immer (client- und serverseitig) mittels eckigen Klammern qualifiziert.
| Measures always (client- and server-side) qualify with square bracket.
| <span {{CoPFormel}}>[Menge]</span>
| <span {{CoPFormel}}>[Quantity]</span>
|-
|-
| '''Filter/Achsenbezug'''
| '''Filter/Axis'''
| Server
| Server
| Filter- und Achsenbezüge werden mittels Attribute-Funktion qualifiziert.
| Filter and axis qualify with 'Attribute'-function.
| <span {{CoPFormel}}>Attribute(Zeit)<br>Attribute(Produke.vs_key)<br>Attribute(PC/KST.Level)</span>
| <span {{CoPFormel}}>Attribute(Period)<br>Attribute(Products.vs_key)<br>Attribute(Profit Center/Cost Center.Level)</span>
|-
|-
| '''Filter/Achsenbezug'''
| '''Filter/Axis'''
| Client
| Client
| Filter- und Achsenbezüge werden mittels eckiger Klammer qualifiziert.
| Filter and axis qualify with square bracket.
| <span {{CoPFormel}}>[Zeit.ID]<br>[Produke.vs_key]<br>[PC/KST.Level]</span><br>
| <span {{CoPFormel}}>[Period.ID]<br>[Products.vs_key]<br>[Profit Center/Cost Center.Level]</span><br>
|-
|-
| '''Funktionen'''
| '''Functions'''
| Server
| Server
|Serverseitige Funktionen: FKT_ Funktionen und die Anwendungseigenschaften. Sessionvariable???
| Server-side functions: FKT_functions and application properties. Session variable???
| <span {{CoPFormel}}>FKT_TimeDimAdd(Y,-1, [bsp_tbl_Zeitfunktionen.dim_sys_zeit_1.COPSYS_ID])</span>  
| <span {{CoPFormel}}>FKT_TimeDimAdd(Y,-1, [bsp_tbl_Periodfunctions.dim_sys_zeit_1.COPSYS_ID])</span>  
|-
|-
| '''Funktionen'''
| '''Functions'''
| Client
| Client
| Clientseitig Funktionen: Funktionen und die Anwendungseigenschaften. Sessionvariable???
| Client-side functions: Functions and application properties. Session variables???
| <span {{CoPFormel}}>TimeDimAdd(M,-12,[Zeit.ID])</span>  
| <span {{CoPFormel}}>TimeDimAdd(M,-12,[Period.ID])</span>  
|}
|}


==Siehe auch==
==See also==
[[Framework:Angeben eines Ausdrucks|Angeben eines Ausdrucks]]<br>
[[Framework:Specify an Expression|Specify an Expression]]<br>
[[Framework:BI_Center:Formeleditor|Formeleditor]]<br>
[[Framework:BI_Center:Formula_Editor|Formula Editor]]<br>
[[Framework:Verwenden von Ausdrücken|Verwenden von Ausdrücken]]
[[Framework:Expression_Uses_in_CoPlanner|Expression Uses in CoPlanner]]




__NOEDITSECTION__  
__NOEDITSECTION__  
<!--
[[Category:Framework|Fundamentals of Expressions]]
[[Category:Framework|Ausdrücke]]
[[Category:BI Center|Fundamentals of Expressions]]
[[Category:BI Center|Ausdrücke]]
 
-->


[[de:Framework:Grundlegendes_zu_Ausdr%C3%BCcken]]
[[de:Framework:Grundlegendes_zu_Ausdr%C3%BCcken]]

Latest revision as of 09:05, 13 December 2012

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

Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=Framework:Fundamentals_of_Expressions&oldid=13830"