Framework:SetMeasureDimension: Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
Created page with "==Function== <span {{CoPFormel}}>ElementFilter(<FilterConst>);</span> This function offers a further possibility to control filter.<br> Please enter in ..."
 
No edit summary
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
==[[Framework:Functions|Function]]==
==[[Framework:Functions|Function]]==


<span {{CoPFormel}}>ElementFilter(<FilterConst>);</span>


This function offers a further possibility to control filter.<br>
<span {{CoPFormel}}>SetMeasureDimension(<Measure>,<Dimension>)</span>
Please enter in property "[[Framework:BI_Center:Input_Mask_-_Dimension_properties|SpecialDefinition]]" of the dimension.
 
Replaces the value of a measure with a dimension element.
Please enter in property "[[Framework:BI_Center:Input_Mask_-_General_properties|SpecialDefinition]]" of the mask. The measure has to be defined as datatype "GrosseGanzzahl".


{| class="wikitable" width="80%"
{| class="wikitable" width="80%"
Line 11: Line 12:
| Description
| Description
|-
|-
|FilterConst
|Measuren
|
|Name of the measures.
:*ONLYPLANTIME Only plan period will be displayed. (Year, Months, Weeks, ... depending on TimeDimType).
|-
:*ONLYPLANTIMEMONTHS Only plan period months will be displayed.
|Dimension
:*ONLYLEAVES Only leaf elements will be displayed.
|Name of the dimension.
|}
|}
 
This function belongs to [[:Category:Functions_-_client-side|client-side functions]].


==Result==
==Result==
Displays only these elements of a filter, which are assigned to the given constant.
Replaces the value of a measure with a dimension element with the corresponding COPSYS_ID.


==Example==
==Example==
<span {{CoPFormel}}>SetMeasureDimension(Calculated Measure_1,Products);</span><br>
Replaces the value of the measure "Calculated Measure_1" with a dimension element of the dimension "Products" with the corresponding COPSYS_ID.


<span {{CoPFormel}}>ElementFilter(ONLYLEAVES);</span><br>
Displays only elements where the condition "ChildCount = 0" is TRUE.
__NOEDITSECTION__  
__NOEDITSECTION__  


[[Category:Functions|SetMeasureDimension]]
[[Category:Functions_-_client-side|SetMeasureDimension]]
[[Category:Functions_-_client-side|SetMeasureDimension]]
[[de:Framework:SetMeasureDimension]]
[[de:Framework:SetMeasureDimension]]

Latest revision as of 07:53, 24 May 2012

Function

SetMeasureDimension(<Measure>,<Dimension>)

Replaces the value of a measure with a dimension element. Please enter in property "SpecialDefinition" of the mask. The measure has to be defined as datatype "GrosseGanzzahl".

Parameter Description
Measuren Name of the measures.
Dimension Name of the dimension.

This function belongs to client-side functions.

Result

Replaces the value of a measure with a dimension element with the corresponding COPSYS_ID.

Example

SetMeasureDimension(Calculated Measure_1,Products);
Replaces the value of the measure "Calculated Measure_1" with a dimension element of the dimension "Products" with the corresponding COPSYS_ID.