HoleFoods.BudgetCube.Fact
persistent class HoleFoods.BudgetCube.Fact extends %DeepSee.FactTable, %DeepSee.CubeFunctionSet
SQL Table Name: HoleFoods_BudgetCube.Fact
Fact table for cube 'HoleFoodsBudget'.THIS IS A GENERATED CLASS, DO NOT EDIT.
Generated by %DeepSee.Generator:%CreateFactTable.
This class was generated by : HoleFoods.BudgetCube.CLS
Property Inventory
- %dspartition
- %sourceId
- Dx475620761
- DxCategoryViaProduct
- DxDateOfSale
- DxDateOfSaleFxDayMonthYear
- DxDateOfSaleFxMonthYear
- DxDateOfSaleFxYear
- DxNameViaCountryViaOutlet
- DxOutlet
- DxProduct
- MxTargetAmount
Method Inventory
- %BuildAllFacts()
- %BuildTempFile()
- %CheckSourceId()
- %Count()
- %DeleteFact()
- %InjectFact()
- %OnEndBatch()
- %OnKillFacts()
- %OnStartBatch()
- %PrecomputeAggregates()
- %ProcessFact()
- %UpdateFacts()
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 = HoleFoodsBudget;
Inherited description: Name of the cube that created this fact table.
parameter INITIALBUILDRESTRICTION = Actual=0;
parameter SOURCECLASS = HoleFoods.Transaction;
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 HoleFoods.Transaction;
Reference to original data in source table.
Property methods: %sourceIdGet(), %sourceIdGetObject(), %sourceIdGetObjectId(), %sourceIdGetStored(), %sourceIdGetSwizzled(), %sourceIdIsValid(), %sourceIdNewObject(), %sourceIdSet(), %sourceIdSetObject(), %sourceIdSetObjectId(), %sourceIdUnSwizzle()
property Dx475620761 as HoleFoods.Cube.Star475620761;
Dimension: Dx475620761
Source: Outlet.Country.Region.Name
Source: Outlet.Country.Region.Name
Property methods: Dx475620761Get(), Dx475620761GetObject(), Dx475620761GetObjectId(), Dx475620761GetStored(), Dx475620761GetSwizzled(), Dx475620761IsValid(), Dx475620761NewObject(), Dx475620761Set(), Dx475620761SetObject(), Dx475620761SetObjectId(), Dx475620761UnSwizzle()
property DxCategoryViaProduct as HoleFoods.Cube.StarCategoryViaProduct;
Dimension: DxCategoryViaProduct
Source: Product.Category
Source: Product.Category
Property methods: DxCategoryViaProductGet(), DxCategoryViaProductGetObject(), DxCategoryViaProductGetObjectId(), DxCategoryViaProductGetStored(), DxCategoryViaProductGetSwizzled(), DxCategoryViaProductIsValid(), DxCategoryViaProductNewObject(), DxCategoryViaProductSet(), DxCategoryViaProductSetObject(), DxCategoryViaProductSetObjectId(), DxCategoryViaProductUnSwizzle()
property DxDateOfSale as %DeepSee.Datatype.dateTime;
Dimension: DxDateOfSale
Source: DateOfSale
Source: DateOfSale
Property methods: DxDateOfSaleDisplayToLogical(), DxDateOfSaleGet(), DxDateOfSaleGetStored(), DxDateOfSaleIsValid(), DxDateOfSaleLogicalToDisplay(), DxDateOfSaleLogicalToOdbc(), DxDateOfSaleNormalize(), DxDateOfSaleOdbcToLogical(), DxDateOfSaleSet()
property DxDateOfSaleFxDayMonthYear as %Library.String (COLLATION = "EXACT") [ Calculated ];
Dimension: DxDateOfSaleFxDayMonthYear
Source: DateOfSale
Source: DateOfSale
Property methods: DxDateOfSaleFxDayMonthYearCompute(), DxDateOfSaleFxDayMonthYearDisplayToLogical(), DxDateOfSaleFxDayMonthYearGet(), DxDateOfSaleFxDayMonthYearIsValid(), DxDateOfSaleFxDayMonthYearLogicalToDisplay(), DxDateOfSaleFxDayMonthYearLogicalToOdbc(), DxDateOfSaleFxDayMonthYearNormalize(), DxDateOfSaleFxDayMonthYearSQLCompute()
property DxDateOfSaleFxMonthYear as %Library.String (COLLATION = "EXACT") [ Calculated ];
Dimension: DxDateOfSaleFxMonthYear
Source: DateOfSale
Source: DateOfSale
Property methods: DxDateOfSaleFxMonthYearCompute(), DxDateOfSaleFxMonthYearDisplayToLogical(), DxDateOfSaleFxMonthYearGet(), DxDateOfSaleFxMonthYearIsValid(), DxDateOfSaleFxMonthYearLogicalToDisplay(), DxDateOfSaleFxMonthYearLogicalToOdbc(), DxDateOfSaleFxMonthYearNormalize(), DxDateOfSaleFxMonthYearSQLCompute()
property DxDateOfSaleFxYear as %Library.String (COLLATION = "EXACT") [ Calculated ];
Dimension: DxDateOfSaleFxYear
Source: DateOfSale
Source: DateOfSale
Property methods: DxDateOfSaleFxYearCompute(), DxDateOfSaleFxYearDisplayToLogical(), DxDateOfSaleFxYearGet(), DxDateOfSaleFxYearIsValid(), DxDateOfSaleFxYearLogicalToDisplay(), DxDateOfSaleFxYearLogicalToOdbc(), DxDateOfSaleFxYearNormalize(), DxDateOfSaleFxYearSQLCompute()
property DxNameViaCountryViaOutlet as HoleFoods.Cube.StarNameViaCountryViaOutlet;
Dimension: DxNameViaCountryViaOutlet
Source: Outlet.Country.Name
Source: Outlet.Country.Name
Property methods: DxNameViaCountryViaOutletGet(), DxNameViaCountryViaOutletGetObject(), DxNameViaCountryViaOutletGetObjectId(), DxNameViaCountryViaOutletGetStored(), DxNameViaCountryViaOutletGetSwizzled(), DxNameViaCountryViaOutletIsValid(), DxNameViaCountryViaOutletNewObject(), DxNameViaCountryViaOutletSet(), DxNameViaCountryViaOutletSetObject(), DxNameViaCountryViaOutletSetObjectId(), DxNameViaCountryViaOutletUnSwizzle()
property DxOutlet as HoleFoods.Cube.StarOutlet;
Dimension: DxOutlet
Source: Outlet
Source: Outlet
Property methods: DxOutletGet(), DxOutletGetObject(), DxOutletGetObjectId(), DxOutletGetStored(), DxOutletGetSwizzled(), DxOutletIsValid(), DxOutletNewObject(), DxOutletSet(), DxOutletSetObject(), DxOutletSetObjectId(), DxOutletUnSwizzle()
property DxProduct as HoleFoods.Cube.StarProduct;
Dimension: DxProduct
Source: Product
Source: Product
Property methods: DxProductGet(), DxProductGetObject(), DxProductGetObjectId(), DxProductGetStored(), DxProductGetSwizzled(), DxProductIsValid(), DxProductNewObject(), DxProductSet(), DxProductSetObject(), DxProductSetObjectId(), DxProductUnSwizzle()
property MxTargetAmount as %Numeric (SCALE = 2);
Measure: MxTargetAmount
Source: TargetAmount
Source: TargetAmount
Property methods: MxTargetAmountDisplayToLogical(), MxTargetAmountGet(), MxTargetAmountGetStored(), MxTargetAmountIsValid(), MxTargetAmountLogicalToDisplay(), MxTargetAmountNormalize(), MxTargetAmountSet()
Methods
Update all Facts with data from the source table.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
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
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
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.
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
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
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
Notification that a batch of facts have just been processed.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
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
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
Notification that a batch of facts are about to be processed.
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
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
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
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
Generated by %DeepSee.Generator:%CreateFactTable.
DO NOT CALL THIS METHOD DIRECTLY
Indexes
index ($Fact on ) [Extent, Type = bitmap];
index (Dx475620761 on Dx475620761) [Type = bitmap];
Index for fact 7.
Index methods: Dx475620761Get(), Dx475620761GetObject(), Dx475620761GetObjectId(), Dx475620761GetStored(), Dx475620761GetSwizzled(), Dx475620761IsValid(), Dx475620761NewObject(), Dx475620761Set(), Dx475620761SetObject(), Dx475620761SetObjectId(), Dx475620761UnSwizzle()
index (Dx475620761ANDDxProduct on Dx475620761,DxProduct) [Type = bitmap];
Index for combination of Dx475620761 and DxProduct.
index (DxCategoryViaProduct on DxCategoryViaProduct) [Type = bitmap];
Index for fact 5.
Index methods: DxCategoryViaProductGet(), DxCategoryViaProductGetObject(), DxCategoryViaProductGetObjectId(), DxCategoryViaProductGetStored(), DxCategoryViaProductGetSwizzled(), DxCategoryViaProductIsValid(), DxCategoryViaProductNewObject(), DxCategoryViaProductSet(), DxCategoryViaProductSetObject(), DxCategoryViaProductSetObjectId(), DxCategoryViaProductUnSwizzle()
index (DxDateOfSaleFxDayMonthYear on DxDateOfSaleFxDayMonthYear) [Type = bitmap];
Index for fact 4.
Index methods: DxDateOfSaleFxDayMonthYearCompute(), DxDateOfSaleFxDayMonthYearDisplayToLogical(), DxDateOfSaleFxDayMonthYearGet(), DxDateOfSaleFxDayMonthYearIsValid(), DxDateOfSaleFxDayMonthYearLogicalToDisplay(), DxDateOfSaleFxDayMonthYearLogicalToOdbc(), DxDateOfSaleFxDayMonthYearNormalize(), DxDateOfSaleFxDayMonthYearSQLCompute()
index (DxDateOfSaleFxMonthYear on DxDateOfSaleFxMonthYear) [Type = bitmap];
Index for fact 3.
Index methods: DxDateOfSaleFxMonthYearCompute(), DxDateOfSaleFxMonthYearDisplayToLogical(), DxDateOfSaleFxMonthYearGet(), DxDateOfSaleFxMonthYearIsValid(), DxDateOfSaleFxMonthYearLogicalToDisplay(), DxDateOfSaleFxMonthYearLogicalToOdbc(), DxDateOfSaleFxMonthYearNormalize(), DxDateOfSaleFxMonthYearSQLCompute()
index (DxDateOfSaleFxYear on DxDateOfSaleFxYear) [Type = bitmap];
Index for fact 2.
Index methods: DxDateOfSaleFxYearCompute(), DxDateOfSaleFxYearDisplayToLogical(), DxDateOfSaleFxYearGet(), DxDateOfSaleFxYearIsValid(), DxDateOfSaleFxYearLogicalToDisplay(), DxDateOfSaleFxYearLogicalToOdbc(), DxDateOfSaleFxYearNormalize(), DxDateOfSaleFxYearSQLCompute()
index (DxDateOfSaleFxYearANDDxProduct on DxDateOfSaleFxYear,DxProduct) [Type = bitmap];
Index for combination of DxDateOfSaleFxYear and DxProduct.
index (DxNameViaCountryViaOutlet on DxNameViaCountryViaOutlet) [Type = bitmap];
Index for fact 8.
Index methods: DxNameViaCountryViaOutletGet(), DxNameViaCountryViaOutletGetObject(), DxNameViaCountryViaOutletGetObjectId(), DxNameViaCountryViaOutletGetStored(), DxNameViaCountryViaOutletGetSwizzled(), DxNameViaCountryViaOutletIsValid(), DxNameViaCountryViaOutletNewObject(), DxNameViaCountryViaOutletSet(), DxNameViaCountryViaOutletSetObject(), DxNameViaCountryViaOutletSetObjectId(), DxNameViaCountryViaOutletUnSwizzle()
index (DxOutlet on DxOutlet) [Type = bitmap];
Index for fact 9.
Index methods: DxOutletGet(), DxOutletGetObject(), DxOutletGetObjectId(), DxOutletGetStored(), DxOutletGetSwizzled(), DxOutletIsValid(), DxOutletNewObject(), DxOutletSet(), DxOutletSetObject(), DxOutletSetObjectId(), DxOutletUnSwizzle()
index (DxProduct on DxProduct) [Type = bitmap];
Index for fact 6.
Index methods: DxProductGet(), DxProductGetObject(), DxProductGetObjectId(), DxProductGetStored(), DxProductGetSwizzled(), DxProductIsValid(), DxProductNewObject(), DxProductSet(), DxProductSetObject(), DxProductSetObjectId(), DxProductUnSwizzle()
index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
index (MxTargetAmount on MxTargetAmount) [Type = bitslice];
Index for measure M1.
Index methods: MxTargetAmountDisplayToLogical(), MxTargetAmountExists(), MxTargetAmountGet(), MxTargetAmountGetStored(), MxTargetAmountIsValid(), MxTargetAmountLogicalToDisplay(), MxTargetAmountNormalize(), MxTargetAmountSet()
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %BMEBuilt()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %ConstructIndices()
- %ConstructIndicesParallel()
- %ConstructIndicesStartTask()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %InsertBatch()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %KillExtentData()
- %LoadFromMemory()
- %LockExtent()
- %LockId()
- %New()
- %NextId()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDetermineClass()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PhysicalAddress()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SaveIndices()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- Log()
- ToLower()
- ToUpper()
Storage
Gray indicates storage defined by superclasses.
Storage Model: CacheStorage (HoleFoods.BudgetCube.Fact)
^DeepSee.Fact("HOLEFOODS.BUDGETCUBE.FACT")(ID) | = | %sourceId
DxDateOfSale
DxCategoryViaProduct
DxProduct
Dx475620761
DxNameViaCountryViaOutlet
DxOutlet
MxTargetAmount
|