Skip to main content

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.Crew.Fact

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

SQL Table Name: Aviation_Cubes_Crew.Fact

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

This class was generated by : Aviation.Cubes.Crew.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 = AviationCrew;
Inherited description: Name of the cube that created this fact table.
parameter SOURCECLASS = Aviation.Crew;
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.Crew;
Reference to original data in source table.
Property methods: %sourceIdGet(), %sourceIdGetObject(), %sourceIdGetObjectId(), %sourceIdGetStored(), %sourceIdGetSwizzled(), %sourceIdIsValid(), %sourceIdNewObject(), %sourceIdSet(), %sourceIdSetObject(), %sourceIdSetObjectId(), %sourceIdUnSwizzle()
property DxAge as Aviation.Cubes.Crew.StarAge;
Dimension: DxAge
Source: Age
Property methods: DxAgeGet(), DxAgeGetObject(), DxAgeGetObjectId(), DxAgeGetStored(), DxAgeGetSwizzled(), DxAgeIsValid(), DxAgeNewObject(), DxAgeSet(), DxAgeSetObject(), DxAgeSetObjectId(), DxAgeUnSwizzle()
property DxAgeRg814105347 as Aviation.Cubes.Crew.StarAgeRg814105347;
Dimension: DxAgeRg814105347
Source: Age
Property methods: DxAgeRg814105347Get(), DxAgeRg814105347GetObject(), DxAgeRg814105347GetObjectId(), DxAgeRg814105347GetStored(), DxAgeRg814105347GetSwizzled(), DxAgeRg814105347IsValid(), DxAgeRg814105347NewObject(), DxAgeRg814105347Set(), DxAgeRg814105347SetObject(), DxAgeRg814105347SetObjectId(), DxAgeRg814105347UnSwizzle()
property DxCategory as Aviation.Cubes.Crew.StarCategory;
Dimension: DxCategory
Source: Category
Property methods: DxCategoryGet(), DxCategoryGetObject(), DxCategoryGetObjectId(), DxCategoryGetStored(), DxCategoryGetSwizzled(), DxCategoryIsValid(), DxCategoryNewObject(), DxCategorySet(), DxCategorySetObject(), DxCategorySetObjectId(), DxCategoryUnSwizzle()
property DxInjury as Aviation.Cubes.Crew.StarInjury;
Dimension: DxInjury
Source: Injury
Property methods: DxInjuryGet(), DxInjuryGetObject(), DxInjuryGetObjectId(), DxInjuryGetStored(), DxInjuryGetSwizzled(), DxInjuryIsValid(), DxInjuryNewObject(), DxInjurySet(), DxInjurySetObject(), DxInjurySetObjectId(), DxInjuryUnSwizzle()
property DxMedicalCertification as Aviation.Cubes.Crew.StarMedicalCertification;
Dimension: DxMedicalCertification
Source: MedicalCertification
Property methods: DxMedicalCertificationGet(), DxMedicalCertificationGetObject(), DxMedicalCertificationGetObjectId(), DxMedicalCertificationGetStored(), DxMedicalCertificationGetSwizzled(), DxMedicalCertificationIsValid(), DxMedicalCertificationNewObject(), DxMedicalCertificationSet(), DxMedicalCertificationSetObject(), DxMedicalCertificationSetObjectId(), DxMedicalCertificationUnSwizzle()
property DxSex as Aviation.Cubes.Crew.StarSex;
Dimension: DxSex
Source: Sex
Property methods: DxSexGet(), DxSexGetObject(), DxSexGetObjectId(), DxSexGetStored(), DxSexGetSwizzled(), DxSexIsValid(), DxSexNewObject(), DxSexSet(), DxSexSetObject(), DxSexSetObjectId(), DxSexUnSwizzle()
property RxAircraft as Aviation.Cubes.Aircraft.Fact;
Relationship: RxAircraft
Source: Aircraft
Property methods: RxAircraftGet(), RxAircraftGetObject(), RxAircraftGetObjectId(), RxAircraftGetStored(), RxAircraftGetSwizzled(), RxAircraftIsValid(), RxAircraftNewObject(), RxAircraftSet(), RxAircraftSetObject(), RxAircraftSetObjectId(), RxAircraftUnSwizzle()

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 (%InverseRxAircraft on %%ID,RxAircraft);
Inverse index for relationship RxAircraft.
Index methods: %InverseRxAircraftExists()
index (DxAge on DxAge) [Type = bitmap];
Index for fact 3.
Index methods: DxAgeGet(), DxAgeGetObject(), DxAgeGetObjectId(), DxAgeGetStored(), DxAgeGetSwizzled(), DxAgeIsValid(), DxAgeNewObject(), DxAgeRg814105347Get(), DxAgeRg814105347GetObject(), DxAgeRg814105347GetObjectId(), DxAgeRg814105347GetStored(), DxAgeRg814105347GetSwizzled(), DxAgeRg814105347IsValid(), DxAgeRg814105347NewObject(), DxAgeRg814105347Set(), DxAgeRg814105347SetObject(), DxAgeRg814105347SetObjectId(), DxAgeRg814105347UnSwizzle(), DxAgeSet(), DxAgeSetObject(), DxAgeSetObjectId(), DxAgeUnSwizzle()
index (DxAgeRg814105347 on DxAgeRg814105347) [Type = bitmap];
Index for fact 2.
Index methods: DxAgeRg814105347Get(), DxAgeRg814105347GetObject(), DxAgeRg814105347GetObjectId(), DxAgeRg814105347GetStored(), DxAgeRg814105347GetSwizzled(), DxAgeRg814105347IsValid(), DxAgeRg814105347NewObject(), DxAgeRg814105347Set(), DxAgeRg814105347SetObject(), DxAgeRg814105347SetObjectId(), DxAgeRg814105347UnSwizzle()
index (DxCategory on DxCategory) [Type = bitmap];
Index for fact 5.
Index methods: DxCategoryGet(), DxCategoryGetObject(), DxCategoryGetObjectId(), DxCategoryGetStored(), DxCategoryGetSwizzled(), DxCategoryIsValid(), DxCategoryNewObject(), DxCategorySet(), DxCategorySetObject(), DxCategorySetObjectId(), DxCategoryUnSwizzle()
index (DxInjury on DxInjury) [Type = bitmap];
Index for fact 6.
Index methods: DxInjuryGet(), DxInjuryGetObject(), DxInjuryGetObjectId(), DxInjuryGetStored(), DxInjuryGetSwizzled(), DxInjuryIsValid(), DxInjuryNewObject(), DxInjurySet(), DxInjurySetObject(), DxInjurySetObjectId(), DxInjuryUnSwizzle()
index (DxMedicalCertification on DxMedicalCertification) [Type = bitmap];
Index for fact 7.
Index methods: DxMedicalCertificationGet(), DxMedicalCertificationGetObject(), DxMedicalCertificationGetObjectId(), DxMedicalCertificationGetStored(), DxMedicalCertificationGetSwizzled(), DxMedicalCertificationIsValid(), DxMedicalCertificationNewObject(), DxMedicalCertificationSet(), DxMedicalCertificationSetObject(), DxMedicalCertificationSetObjectId(), DxMedicalCertificationUnSwizzle()
index (DxSex on DxSex) [Type = bitmap];
Index for fact 4.
Index methods: DxSexGet(), DxSexGetObject(), DxSexGetObjectId(), DxSexGetStored(), DxSexGetSwizzled(), DxSexIsValid(), DxSexNewObject(), DxSexSet(), DxSexSetObject(), DxSexSetObjectId(), DxSexUnSwizzle()
index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
index (RxAircraft on RxAircraft) [Type = bitmap];
Index for fact 8.
Index methods: RxAircraftGet(), RxAircraftGetObject(), RxAircraftGetObjectId(), RxAircraftGetStored(), RxAircraftGetSwizzled(), RxAircraftIsValid(), RxAircraftNewObject(), RxAircraftSet(), RxAircraftSetObject(), RxAircraftSetObjectId(), RxAircraftUnSwizzle()

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

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

^DeepSee.Fact("AVIATION.CUBES.CREW.FACT")(ID)
=
%sourceId
DxAgeRg814105347
DxAge
DxSex
DxCategory
DxInjury
DxMedicalCertification
RxAircraft
FeedbackOpens in a new tab