DOCUMENTATIONAPI REFERENCEAI-Link
DownloadsSupport
Loading search results...
Working with CubesCreating CubesFormats for Data ValuesBoolean Format Strings

Boolean Format Strings

You can specify how values are formatted for attributes of BOOLEAN data types.

Built-in Boolean Formats

Format NameDescription
Yes/NoDisplays Yes for true and No for false.

For numeric values, displays No if the number is 0; otherwise, displays Yes.
True/FalseDisplays True for true and False for false.

For numeric values, displays False if the number is 0; otherwise, displays True.
On/OffDisplays On for true and Off for false.

For numeric values, displays Off if the number is 0; otherwise, displays On.

Custom Boolean Formats

If you choose Custom as the format, you can supply a format string to specify how to format Boolean values if the values are in numeric format (ones and zeros to represent true and false). See the custom format characters for Number Format Strings.