DOCUMENTATIONAPI REFERENCEAI-Link
DownloadsSupport
Loading search results...
Working with CubesCreating CubesModeling Cube MeasuresAdd Calculated MeasuresMDX ReferenceCBOOL

CBOOL

Casts the value to a Boolean. Returns False for String or Numeric expressions that evaluate to zero, else returns true.

Syntax 

CBOOL(Value_Expression)

Input Parameters

Value Expression

Return Value

Returns a Boolean.

Example

A calculated expression to detect if the current level of the Order Retail445 hierarchy is the root level.

NOT CBOOL([Order Date Dimension].[Order Retail445].currentMember.LEVEL_NUMBER)