Sorry, your browser does not support JavaScript or JavaScript is disabled. Please enable JavaScript or use another browser to have a better experience.

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.Opens in a new tab

For information on migrating to InterSystems IRISOpens in a new tab, see Why Migrate to InterSystems IRIS?

Thanks for your feedback!
Need to tell us more? Click here or use the Feedback button.

Is this page helpful?

Class Details

Properties (27)
Queries (1)
Indexes (2)
Inherited Members
Storage

Show private members

%BI.DataType

persistent class %BI.DataType extends %Library.Persistent

SQL Table Name: %BI.DataType

Property Inventory

Properties

property BaseType as %String (TRUNCATE = 1);

Property methods: BaseTypeDisplayToLogical(), BaseTypeGet(), BaseTypeGetStored(), BaseTypeIsValid(), BaseTypeLogicalToDisplay(), BaseTypeLogicalToOdbc(), BaseTypeNormalize(), BaseTypeSet()

property CustomDimension as %String (MAXLEN = 30000, TRUNCATE = 1);

Property methods: CustomDimensionDisplayToLogical(), CustomDimensionGet(), CustomDimensionGetStored(), CustomDimensionIsValid(), CustomDimensionLogicalToDisplay(), CustomDimensionLogicalToOdbc(), CustomDimensionNormalize(), CustomDimensionSet()

property DOW as %Boolean;

Property methods: DOWDisplayToLogical(), DOWGet(), DOWGetStored(), DOWIsValid(), DOWLogicalToDisplay(), DOWNormalize(), DOWSet()

property Day as %Boolean;

Property methods: DayDisplayToLogical(), DayGet(), DayGetStored(), DayIsValid(), DayLogicalToDisplay(), DayNormalize(), DaySet()

property DecPoint as %SmallInt;

Property methods: DecPointDisplayToLogical(), DecPointGet(), DecPointGetStored(), DecPointIsValid(), DecPointLogicalToDisplay(), DecPointNormalize(), DecPointSet()

property Delimiter as %String (TRUNCATE = 1);

Property methods: DelimiterDisplayToLogical(), DelimiterGet(), DelimiterGetStored(), DelimiterIsValid(), DelimiterLogicalToDisplay(), DelimiterLogicalToOdbc(), DelimiterNormalize(), DelimiterSet()

property ExcludedWords as %String (MAXLEN = 30000, TRUNCATE = 1);

Property methods: ExcludedWordsDisplayToLogical(), ExcludedWordsGet(), ExcludedWordsGetStored(), ExcludedWordsIsValid(), ExcludedWordsLogicalToDisplay(), ExcludedWordsLogicalToOdbc(), ExcludedWordsNormalize(), ExcludedWordsSet()

property HrRng as %Boolean;

Property methods: HrRngDisplayToLogical(), HrRngGet(), HrRngGetStored(), HrRngIsValid(), HrRngLogicalToDisplay(), HrRngNormalize(), HrRngSet()

property MBitMap as array of %BI.BitMapType;

Property methods: MBitMapBuildValueArray(), MBitMapCollectionToDisplay(), MBitMapCollectionToOdbc(), MBitMapDisplayToCollection(), MBitMapGet(), MBitMapGetObject(), MBitMapGetObjectId(), MBitMapGetStored(), MBitMapGetSwizzled(), MBitMapIsValid(), MBitMapOdbcToCollection(), MBitMapSet(), MBitMapSetObject(), MBitMapSetObjectId()

property MinChar as %String (TRUNCATE = 1);

Property methods: MinCharDisplayToLogical(), MinCharGet(), MinCharGetStored(), MinCharIsValid(), MinCharLogicalToDisplay(), MinCharLogicalToOdbc(), MinCharNormalize(), MinCharSet()

property Mth as %Boolean;

Property methods: MthDisplayToLogical(), MthGet(), MthGetStored(), MthIsValid(), MthLogicalToDisplay(), MthNormalize(), MthSet()

property MthWeek as %Boolean;

Property methods: MthWeekDisplayToLogical(), MthWeekGet(), MthWeekGetStored(), MthWeekIsValid(), MthWeekLogicalToDisplay(), MthWeekNormalize(), MthWeekSet()

property NullField as %String (TRUNCATE = 1);

Property methods: NullFieldDisplayToLogical(), NullFieldGet(), NullFieldGetStored(), NullFieldIsValid(), NullFieldLogicalToDisplay(), NullFieldLogicalToOdbc(), NullFieldNormalize(), NullFieldSet()

property NullPointer as %String (TRUNCATE = 1);

Property methods: NullPointerDisplayToLogical(), NullPointerGet(), NullPointerGetStored(), NullPointerIsValid(), NullPointerLogicalToDisplay(), NullPointerLogicalToOdbc(), NullPointerNormalize(), NullPointerSet()

property Per as %Boolean;

Property methods: PerDisplayToLogical(), PerGet(), PerGetStored(), PerIsValid(), PerLogicalToDisplay(), PerNormalize(), PerSet()

property Qtr as %Boolean;

Property methods: QtrDisplayToLogical(), QtrGet(), QtrGetStored(), QtrIsValid(), QtrLogicalToDisplay(), QtrNormalize(), QtrSet()

property Rounding as %Boolean;

Property methods: RoundingDisplayToLogical(), RoundingGet(), RoundingGetStored(), RoundingIsValid(), RoundingLogicalToDisplay(), RoundingNormalize(), RoundingSet()

property StartFinPeriod as %String (TRUNCATE = 1);

Property methods: StartFinPeriodDisplayToLogical(), StartFinPeriodGet(), StartFinPeriodGetStored(), StartFinPeriodIsValid(), StartFinPeriodLogicalToDisplay(), StartFinPeriodLogicalToOdbc(), StartFinPeriodNormalize(), StartFinPeriodSet()

property TS as %Boolean;

Property methods: TSDisplayToLogical(), TSGet(), TSGetStored(), TSIsValid(), TSLogicalToDisplay(), TSNormalize(), TSSet()

property TextConversion as %Integer;

Property methods: TextConversionDisplayToLogical(), TextConversionGet(), TextConversionGetStored(), TextConversionIsValid(), TextConversionLogicalToDisplay(), TextConversionNormalize(), TextConversionSet()

property TypeName as %String (TRUNCATE = 1);

Property methods: TypeNameDisplayToLogical(), TypeNameGet(), TypeNameGetStored(), TypeNameIsValid(), TypeNameLogicalToDisplay(), TypeNameLogicalToOdbc(), TypeNameNormalize(), TypeNameSet()

property UseExternalValue as %Boolean;

Property methods: UseExternalValueDisplayToLogical(), UseExternalValueGet(), UseExternalValueGetStored(), UseExternalValueIsValid(), UseExternalValueLogicalToDisplay(), UseExternalValueNormalize(), UseExternalValueSet()

property Wk as %Boolean;

Property methods: WkDisplayToLogical(), WkGet(), WkGetStored(), WkIsValid(), WkLogicalToDisplay(), WkNormalize(), WkSet()

property Yr as %Boolean;

Property methods: YrDisplayToLogical(), YrGet(), YrGetStored(), YrIsValid(), YrLogicalToDisplay(), YrNormalize(), YrSet()

property childFunc as %Integer;

Property methods: childFuncDisplayToLogical(), childFuncGet(), childFuncGetStored(), childFuncIsValid(), childFuncLogicalToDisplay(), childFuncNormalize(), childFuncSet()

property coltseq as %Integer;

Property methods: coltseqDisplayToLogical(), coltseqGet(), coltseqGetStored(), coltseqIsValid(), coltseqLogicalToDisplay(), coltseqNormalize(), coltseqSet()

property initialization as %String (TRUNCATE = 1);

Property methods: initializationDisplayToLogical(), initializationGet(), initializationGetStored(), initializationIsValid(), initializationLogicalToDisplay(), initializationLogicalToOdbc(), initializationNormalize(), initializationSet()

Queries

query ListAll()

SQL Query:
SELECT ID, TypeName FROM %BI.DataType

Indexes

index (IDKEY on ) [IdKey, Type = key];

Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

index (Name on TypeName:Exact);

Index methods: NameExists()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (%BI.DataType)

^BI.DataTypeD(ID,"B")

MBitmap

Storage Model: CacheStorage (%BI.DataType)

^BI.DataTypeD(ID,"C")

%%CLASSNAME

Storage Model: CacheStorage (%BI.DataType)

^BI.DataTypeD(ID,"D")

CustomDimension

Storage Model: CacheStorage (%BI.DataType)

^BI.DataTypeD(ID)

BaseType

DecPoint

Rounding

TypeName

DOW

Day

Mth

Qtr

Per

TextConversion

Delimiter

MinChar

CustomDateTag

CustomDateMethod

NullField

NullPointer

UseExternalValue

initialization

StartFinPeriod

ExcludedWords

MthWeek

childFunc

coltseq

HrRng

Storage Model: CacheStorage (%BI.DataType)

^BI.DataTypeD(ID,"MBitMap",n)

MBitMap(n)

Feedback