Skip to main content

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?

This version of the product is no longer supported, and this documentation is no longer updated regularly. See the latest version of this content.Opens in a new tab

Aviation.Cubes.Events.Fact

persistent class Aviation.Cubes.Events.Fact extends %DeepSee.FactTable, %DeepSee.CubeFunctionSet

SQL Table Name: Aviation_Cubes_Events.Fact

Fact table for cube 'AviationEvents'.
THIS IS A GENERATED CLASS, DO NOT EDIT.
Generated by %DeepSee.Generator:%CreateFactTable.

This class was generated by : Aviation.Cubes.Events.CLS

Property Inventory

Method Inventory

Parameters

parameter BITMAPCHUNKINMEMORY = 0;
Inherited description: BITMAPCHUNKINMEMORY is used during code generation to decide whether or not bitmap chunks can be constructed in memory. It is faster to construct bitmap chunks in memory but if there are a lot of bitmaps, the indexed property or properties have very low selectivity or the index values are large then STORE errors can be encountered. If BITMAPCHUNKINMEMORY is 1 then bitmap chunks are constructed in memory by %ConstructIndices. Otherwise, bitmap chunks are constructed using process-private globals. The default is 0, meaning that bitmap chunks are built using process-private globals.
parameter CUBENAME = AviationEvents;
Inherited description: Name of the cube that created this fact table.
parameter SOURCECLASS = Aviation.Event;
Inherited description: Name of the source table that provides data for this fact table.

Properties

property %dspartition as %Integer [ Calculated ];
This indicates which partition (set of 1M) this fact is in.
Property methods: %dspartitionCompute(), %dspartitionDisplayToLogical(), %dspartitionGet(), %dspartitionIsValid(), %dspartitionLogicalToDisplay(), %dspartitionNormalize(), %dspartitionSQLCompute()
property %sourceId as Aviation.Event;
Reference to original data in source table.
Property methods: %sourceIdGet(), %sourceIdGetObject(), %sourceIdGetObjectId(), %sourceIdGetStored(), %sourceIdGetSwizzled(), %sourceIdIsValid(), %sourceIdNewObject(), %sourceIdSet(), %sourceIdSetObject(), %sourceIdSetObjectId(), %sourceIdUnSwizzle()
property Dx3610825905 as Aviation.Cubes.Events.Star3610825905;
Dimension: Dx3610825905 Expression: $s(%source.LocationCountry="USA":%cube.%Lookup("USStateCodes", %source.LocationState), 1:%source.LocationState)
Property methods: Dx3610825905Get(), Dx3610825905GetObject(), Dx3610825905GetObjectId(), Dx3610825905GetStored(), Dx3610825905GetSwizzled(), Dx3610825905IsValid(), Dx3610825905NewObject(), Dx3610825905Set(), Dx3610825905SetObject(), Dx3610825905SetObjectId(), Dx3610825905UnSwizzle()
property Dx627747261 as Aviation.Cubes.Events.Star627747261;
Dimension: Dx627747261 Expression: %cube.%Lookup("CountryCodes", %source.LocationCountry)
Property methods: Dx627747261Get(), Dx627747261GetObject(), Dx627747261GetObjectId(), Dx627747261GetStored(), Dx627747261GetSwizzled(), Dx627747261IsValid(), Dx627747261NewObject(), Dx627747261Set(), Dx627747261SetObject(), Dx627747261SetObjectId(), Dx627747261UnSwizzle()
property DxEventDate as %DeepSee.Datatype.dateTime;
Dimension: DxEventDate
Source: EventDate
Property methods: DxEventDateDisplayToLogical(), DxEventDateGet(), DxEventDateGetStored(), DxEventDateIsValid(), DxEventDateLogicalToDisplay(), DxEventDateLogicalToOdbc(), DxEventDateNormalize(), DxEventDateOdbcToLogical(), DxEventDateSet()
property DxEventDateFxDayNumber as %Library.String (COLLATION = "EXACT") [ Calculated ];
Dimension: DxEventDateFxDayNumber
Source: EventDate
Property methods: DxEventDateFxDayNumberCompute(), DxEventDateFxDayNumberDisplayToLogical(), DxEventDateFxDayNumberGet(), DxEventDateFxDayNumberIsValid(), DxEventDateFxDayNumberLogicalToDisplay(), DxEventDateFxDayNumberLogicalToOdbc(), DxEventDateFxDayNumberNormalize(), DxEventDateFxDayNumberSQLCompute()
property DxEventDateFxMonthNumber as %Library.String (COLLATION = "EXACT") [ Calculated ];
Dimension: DxEventDateFxMonthNumber
Source: EventDate
Property methods: DxEventDateFxMonthNumberCompute(), DxEventDateFxMonthNumberDisplayToLogical(), DxEventDateFxMonthNumberGet(), DxEventDateFxMonthNumberIsValid(), DxEventDateFxMonthNumberLogicalToDisplay(), DxEventDateFxMonthNumberLogicalToOdbc(), DxEventDateFxMonthNumberNormalize(), DxEventDateFxMonthNumberSQLCompute()
property DxEventDateFxYear as %Library.String (COLLATION = "EXACT") [ Calculated ];
Dimension: DxEventDateFxYear
Source: EventDate
Property methods: DxEventDateFxYearCompute(), DxEventDateFxYearDisplayToLogical(), DxEventDateFxYearGet(), DxEventDateFxYearIsValid(), DxEventDateFxYearLogicalToDisplay(), DxEventDateFxYearLogicalToOdbc(), DxEventDateFxYearNormalize(), DxEventDateFxYearSQLCompute()
property DxInjuriesHighest as Aviation.Cubes.Events.StarInjuriesHighest;
Dimension: DxInjuriesHighest
Source: InjuriesHighest
Property methods: DxInjuriesHighestGet(), DxInjuriesHighestGetObject(), DxInjuriesHighestGetObjectId(), DxInjuriesHighestGetStored(), DxInjuriesHighestGetSwizzled(), DxInjuriesHighestIsValid(), DxInjuriesHighestNewObject(), DxInjuriesHighestSet(), DxInjuriesHighestSetObject(), DxInjuriesHighestSetObjectId(), DxInjuriesHighestUnSwizzle()
property DxMidAir as Aviation.Cubes.Events.StarMidAir;
Dimension: DxMidAir
Source: MidAir
Property methods: DxMidAirGet(), DxMidAirGetObject(), DxMidAirGetObjectId(), DxMidAirGetStored(), DxMidAirGetSwizzled(), DxMidAirIsValid(), DxMidAirNewObject(), DxMidAirSet(), DxMidAirSetObject(), DxMidAirSetObjectId(), DxMidAirUnSwizzle()
property DxSkyConditionNonCeiling as Aviation.Cubes.Events.StarSkyConditionNonCeiling;
Dimension: DxSkyConditionNonCeiling
Source: SkyConditionNonCeiling
Property methods: DxSkyConditionNonCeilingGet(), DxSkyConditionNonCeilingGetObject(), DxSkyConditionNonCeilingGetObjectId(), DxSkyConditionNonCeilingGetStored(), DxSkyConditionNonCeilingGetSwizzled(), DxSkyConditionNonCeilingIsValid(), DxSkyConditionNonCeilingNewObject(), DxSkyConditionNonCeilingSet(), DxSkyConditionNonCeilingSetObject(), DxSkyConditionNonCeilingSetObjectId(), DxSkyConditionNonCeilingUnSwizzle()
property MxInjuriesTotalN as %Double (SCALE = 2);
Measure: MxInjuriesTotalN
Source: InjuriesTotal
Property methods: MxInjuriesTotalNDisplayToLogical(), MxInjuriesTotalNGet(), MxInjuriesTotalNGetStored(), MxInjuriesTotalNIsValid(), MxInjuriesTotalNLogicalToDisplay(), MxInjuriesTotalNNormalize(), MxInjuriesTotalNOdbcToLogical(), MxInjuriesTotalNSet()

Methods

classmethod %BuildAllFacts(pVerbose As %Boolean = 0) as %Status
Update all Facts with data from the source table.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
classmethod %BuildTempFile(pTempKey As %String, Output pImplemented As %Boolean, pVerbose As %Boolean = 0) as %Status
Create a temp file of all source ids.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
classmethod %CheckSourceId(pTestId As %String, pVerbose As %Boolean = 0, Output pSC As %Status) as %Boolean
Check for the existence of a single ID in the source table.
DO NOT CALL THIS METHOD DIRECTLY
classmethod %Count() as %Integer
Return the total number of items within the Fact table.
Generated by %DeepSee.Generator:%CreateFactTable.
classmethod %DeleteFact(pID As %String, Output pFactId As %Integer, Output pErrorMsg As %String) as %Status
Perform the work of deleting one fact in the cube.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
classmethod %InjectFact(ByRef pFactId As %Integer, ByRef pValues As %String, Output pChunks As %Integer, pDimensionsOnly As %Boolean = 0) as %Status
Perform the work of injecting one fact into the cube without associated source data.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
classmethod %OnEndBatch(pCubeName As %String, pVerbose As %Boolean = 0) as %Status
Notification that a batch of facts have just been processed.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
classmethod %OnKillFacts() as %Status
Notification that this cube is being killed.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
classmethod %OnStartBatch(pCubeName As %String, pVerbose As %Boolean = 0) as %Status
Notification that a batch of facts are about to be processed.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
classmethod %PrecomputeAggregates(pStartChunk As %Integer, pEndChunk As %Integer, pAggGLVN As %String, pVerbose As %Boolean = 0, pTaskGroup As %String = "", ByRef pCount As %Integer = 0) as %Status
Pre-compute certain aggregates.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
classmethod %ProcessFact(pID As %String, pBatchMode As %Boolean = 0, ByRef %var As %String, ByRef pFactId As %Integer, Output pErrorMsg As %String, ByRef pDimTables, pDimensionsOnly As %Boolean = 0) as %Status
Perform the work of updating one fact in the cube.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
classmethod %UpdateFacts(pStartId As %String, pEndId As %String, pBatchMode As %Boolean = 0, ByRef pChunks As %Integer, pVerbose As %Boolean = 0, pTaskGroup As %String = "", Output pUpdates As %Integer, pRefProp As %String = "", pRefID As %String = "", ByRef pDimTables) as %Status
Update a range of Facts with data from the source table row with ids from pStartId to pEndId.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY

Indexes

index ($Fact on ) [Extent, Type = bitmap];
index (Dx3610825905 on Dx3610825905) [Type = bitmap];
Index for fact 6.
Index methods: Dx3610825905Get(), Dx3610825905GetObject(), Dx3610825905GetObjectId(), Dx3610825905GetStored(), Dx3610825905GetSwizzled(), Dx3610825905IsValid(), Dx3610825905NewObject(), Dx3610825905Set(), Dx3610825905SetObject(), Dx3610825905SetObjectId(), Dx3610825905UnSwizzle()
index (Dx627747261 on Dx627747261) [Type = bitmap];
Index for fact 5.
Index methods: Dx627747261Get(), Dx627747261GetObject(), Dx627747261GetObjectId(), Dx627747261GetStored(), Dx627747261GetSwizzled(), Dx627747261IsValid(), Dx627747261NewObject(), Dx627747261Set(), Dx627747261SetObject(), Dx627747261SetObjectId(), Dx627747261UnSwizzle()
index (DxEventDateFxDayNumber on DxEventDateFxDayNumber) [Type = bitmap];
Index for fact 4.
Index methods: DxEventDateFxDayNumberCompute(), DxEventDateFxDayNumberDisplayToLogical(), DxEventDateFxDayNumberGet(), DxEventDateFxDayNumberIsValid(), DxEventDateFxDayNumberLogicalToDisplay(), DxEventDateFxDayNumberLogicalToOdbc(), DxEventDateFxDayNumberNormalize(), DxEventDateFxDayNumberSQLCompute()
index (DxEventDateFxMonthNumber on DxEventDateFxMonthNumber) [Type = bitmap];
Index for fact 3.
Index methods: DxEventDateFxMonthNumberCompute(), DxEventDateFxMonthNumberDisplayToLogical(), DxEventDateFxMonthNumberGet(), DxEventDateFxMonthNumberIsValid(), DxEventDateFxMonthNumberLogicalToDisplay(), DxEventDateFxMonthNumberLogicalToOdbc(), DxEventDateFxMonthNumberNormalize(), DxEventDateFxMonthNumberSQLCompute()
index (DxEventDateFxYear on DxEventDateFxYear) [Type = bitmap];
Index for fact 2.
Index methods: DxEventDateFxYearCompute(), DxEventDateFxYearDisplayToLogical(), DxEventDateFxYearGet(), DxEventDateFxYearIsValid(), DxEventDateFxYearLogicalToDisplay(), DxEventDateFxYearLogicalToOdbc(), DxEventDateFxYearNormalize(), DxEventDateFxYearSQLCompute()
index (DxInjuriesHighest on DxInjuriesHighest) [Type = bitmap];
Index for fact 9.
Index methods: DxInjuriesHighestGet(), DxInjuriesHighestGetObject(), DxInjuriesHighestGetObjectId(), DxInjuriesHighestGetStored(), DxInjuriesHighestGetSwizzled(), DxInjuriesHighestIsValid(), DxInjuriesHighestNewObject(), DxInjuriesHighestSet(), DxInjuriesHighestSetObject(), DxInjuriesHighestSetObjectId(), DxInjuriesHighestUnSwizzle()
index (DxMidAir on DxMidAir) [Type = bitmap];
Index for fact 8.
Index methods: DxMidAirGet(), DxMidAirGetObject(), DxMidAirGetObjectId(), DxMidAirGetStored(), DxMidAirGetSwizzled(), DxMidAirIsValid(), DxMidAirNewObject(), DxMidAirSet(), DxMidAirSetObject(), DxMidAirSetObjectId(), DxMidAirUnSwizzle()
index (DxSkyConditionNonCeiling on DxSkyConditionNonCeiling) [Type = bitmap];
Index for fact 7.
Index methods: DxSkyConditionNonCeilingGet(), DxSkyConditionNonCeilingGetObject(), DxSkyConditionNonCeilingGetObjectId(), DxSkyConditionNonCeilingGetStored(), DxSkyConditionNonCeilingGetSwizzled(), DxSkyConditionNonCeilingIsValid(), DxSkyConditionNonCeilingNewObject(), DxSkyConditionNonCeilingSet(), DxSkyConditionNonCeilingSetObject(), DxSkyConditionNonCeilingSetObjectId(), DxSkyConditionNonCeilingUnSwizzle()
index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
index (MxInjuriesTotalN on MxInjuriesTotalN) [Type = bitslice];
Index for measure M2.
Index methods: MxInjuriesTotalNDisplayToLogical(), MxInjuriesTotalNExists(), MxInjuriesTotalNGet(), MxInjuriesTotalNGetStored(), MxInjuriesTotalNIsValid(), MxInjuriesTotalNLogicalToDisplay(), MxInjuriesTotalNNormalize(), MxInjuriesTotalNOdbcToLogical(), MxInjuriesTotalNSet()

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: CacheStorage (Aviation.Cubes.Events.Fact)

^DeepSee.Fact("AVIATION.CUBES.EVENTS.FACT")(ID)
 =
%sourceId
DxEventDate
Dx627747261
Dx3610825905
DxSkyConditionNonCeiling
DxMidAir
DxInjuriesHighest
MxInjuriesTotalN
FeedbackOpens in a new tab