What does the II and the ( and the ) mean in the expression on measures list of Operators? Please provide examples and definition
II indicates the 'OR' operator which is used to take care of otherwise expressions. E.g. Unit Sales == 500 II Unit Sales !=1000 (Unit Sales equals 500 or not equal to 1000). ( ) indicates opening and closing braces generally used to specify multiple conditions. E.g. Average Inventory Cost Expression: (SUM(C318) + SUM(CASE WHEN DATE_KEY = #startenddatekey# THEN C175 ELSE 0 END)) / (#monthdiff# + 1)
Related Articles
Not able to provide security for some of the measures. Why?
The measures could be Dimensional Measures (i.e, measure created using Dimension table column, or under Dimensions group). You cannot apply Measure security for Dimensional Measures.
Can we use computed measures in an expression measure?
Computed measures cannot be used in an Expression measure.
Why are the associated measures not accompanied when Expression measures are dragged to publish a KPI?
In most of the cases, base measures are not required to be displayed in the KPI. So when a measure is not required, it has to be hidden using the Show/Hide feature. To prevent the step of using Show/Hide feature, the associated base measures do not ...
While publishing a KPI, if an Expression measure is dragged, the associated base measures are not accompanied. Why?
Most of the times, these base measures may not be required to be shown in the KPI, hence these base measures should alternatively be hidden using the Show/Hide feature. To prevent this additional step, when an Expression measure is dragged, the ...
While publishing a KPI, if an Expression measure is dragged, the associated base measures are not accompanied.
Most of the times, these base measures may not be required to be shown in the KPI, hence these base measures should alternatively be hidden using the Show/Hide feature. To prevent this additional step, when an Expression measure is dragged, the ...