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?

HoleFoods.Cube.Fact

persistent class HoleFoods.Cube.Fact extends %DeepSee.FactTable, %DeepSee.CubeFunctionSet

SQL Table Name: HoleFoods_Cube.Fact

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

This class was generated by : HoleFoods.Cube.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 = HoleFoods;
Inherited description: Name of the cube that created this fact table.
parameter INITIALBUILDRESTRICTION = Actual=1;
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
Property methods: Dx475620761Get(), Dx475620761GetObject(), Dx475620761GetObjectId(), Dx475620761GetStored(), Dx475620761GetSwizzled(), Dx475620761IsValid(), Dx475620761NewObject(), Dx475620761Set(), Dx475620761SetObject(), Dx475620761SetObjectId(), Dx475620761UnSwizzle()
property DxCategoryViaProduct as HoleFoods.Cube.StarCategoryViaProduct;
Dimension: DxCategoryViaProduct
Source: Product.Category
Property methods: DxCategoryViaProductGet(), DxCategoryViaProductGetObject(), DxCategoryViaProductGetObjectId(), DxCategoryViaProductGetStored(), DxCategoryViaProductGetSwizzled(), DxCategoryViaProductIsValid(), DxCategoryViaProductNewObject(), DxCategoryViaProductSet(), DxCategoryViaProductSetObject(), DxCategoryViaProductSetObjectId(), DxCategoryViaProductUnSwizzle()
property DxChannel as HoleFoods.Cube.StarChannel;
Dimension: DxChannel
Source: Channel
Property methods: DxChannelGet(), DxChannelGetObject(), DxChannelGetObjectId(), DxChannelGetStored(), DxChannelGetSwizzled(), DxChannelIsValid(), DxChannelNewObject(), DxChannelSet(), DxChannelSetObject(), DxChannelSetObjectId(), DxChannelUnSwizzle()
property DxDateOfSale as %DeepSee.Datatype.dateTime;
Dimension: DxDateOfSale
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
Property methods: DxDateOfSaleFxDayMonthYearCompute(), DxDateOfSaleFxDayMonthYearDisplayToLogical(), DxDateOfSaleFxDayMonthYearGet(), DxDateOfSaleFxDayMonthYearIsValid(), DxDateOfSaleFxDayMonthYearLogicalToDisplay(), DxDateOfSaleFxDayMonthYearLogicalToOdbc(), DxDateOfSaleFxDayMonthYearNormalize(), DxDateOfSaleFxDayMonthYearSQLCompute()
property DxDateOfSaleFxMonthYear as %Library.String (COLLATION = "EXACT") [ Calculated ];
Dimension: DxDateOfSaleFxMonthYear
Source: DateOfSale
Property methods: DxDateOfSaleFxMonthYearCompute(), DxDateOfSaleFxMonthYearDisplayToLogical(), DxDateOfSaleFxMonthYearGet(), DxDateOfSaleFxMonthYearIsValid(), DxDateOfSaleFxMonthYearLogicalToDisplay(), DxDateOfSaleFxMonthYearLogicalToOdbc(), DxDateOfSaleFxMonthYearNormalize(), DxDateOfSaleFxMonthYearSQLCompute()
property DxDateOfSaleFxYear as %Library.String (COLLATION = "EXACT") [ Calculated ];
Dimension: DxDateOfSaleFxYear
Source: DateOfSale
Property methods: DxDateOfSaleFxYearCompute(), DxDateOfSaleFxYearDisplayToLogical(), DxDateOfSaleFxYearGet(), DxDateOfSaleFxYearIsValid(), DxDateOfSaleFxYearLogicalToDisplay(), DxDateOfSaleFxYearLogicalToOdbc(), DxDateOfSaleFxYearNormalize(), DxDateOfSaleFxYearSQLCompute()
property DxDiscountRg857767687 as HoleFoods.Cube.StarDiscountRg857767687;
Dimension: DxDiscountRg857767687
Source: Discount
Property methods: DxDiscountRg857767687Get(), DxDiscountRg857767687GetObject(), DxDiscountRg857767687GetObjectId(), DxDiscountRg857767687GetStored(), DxDiscountRg857767687GetSwizzled(), DxDiscountRg857767687IsValid(), DxDiscountRg857767687NewObject(), DxDiscountRg857767687Set(), DxDiscountRg857767687SetObject(), DxDiscountRg857767687SetObjectId(), DxDiscountRg857767687UnSwizzle()
property DxNameViaCountryViaOutlet as HoleFoods.Cube.StarNameViaCountryViaOutlet;
Dimension: DxNameViaCountryViaOutlet
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
Property methods: DxOutletGet(), DxOutletGetObject(), DxOutletGetObjectId(), DxOutletGetStored(), DxOutletGetSwizzled(), DxOutletIsValid(), DxOutletNewObject(), DxOutletSet(), DxOutletSetObject(), DxOutletSetObjectId(), DxOutletUnSwizzle()
property DxProduct as HoleFoods.Cube.StarProduct;
Dimension: DxProduct
Source: Product
Property methods: DxProductGet(), DxProductGetObject(), DxProductGetObjectId(), DxProductGetStored(), DxProductGetSwizzled(), DxProductIsValid(), DxProductNewObject(), DxProductSet(), DxProductSetObject(), DxProductSetObjectId(), DxProductUnSwizzle()
property DxUnitsSold as HoleFoods.Cube.StarUnitsSold;
Dimension: DxUnitsSold
Source: UnitsSold
Property methods: DxUnitsSoldGet(), DxUnitsSoldGetObject(), DxUnitsSoldGetObjectId(), DxUnitsSoldGetStored(), DxUnitsSoldGetSwizzled(), DxUnitsSoldIsValid(), DxUnitsSoldNewObject(), DxUnitsSoldSet(), DxUnitsSoldSetObject(), DxUnitsSoldSetObjectId(), DxUnitsSoldUnSwizzle()
property Mx1094836251B as %Boolean;
Measure: Mx1094836251B Expression: $S(%source.UnitsSold="":"",%source.UnitsSold>5:1,1:0)
Property methods: Mx1094836251BDisplayToLogical(), Mx1094836251BGet(), Mx1094836251BGetStored(), Mx1094836251BIsValid(), Mx1094836251BLogicalToDisplay(), Mx1094836251BNormalize(), Mx1094836251BSet()
property MxAmountOfSale as %Numeric (SCALE = 2);
Measure: MxAmountOfSale
Source: AmountOfSale
Property methods: MxAmountOfSaleDisplayToLogical(), MxAmountOfSaleGet(), MxAmountOfSaleGetStored(), MxAmountOfSaleIsValid(), MxAmountOfSaleLogicalToDisplay(), MxAmountOfSaleNormalize(), MxAmountOfSaleSet()
property MxComment as %Text (MAXLEN = 500);
Measure: MxComment
Source: Comment
Property methods: MxCommentBuildValueArray(), MxCommentChooseSearchKey(), MxCommentCreateQList(), MxCommentDisplayToLogical(), MxCommentGet(), MxCommentGetStored(), MxCommentIsValid(), MxCommentLogicalToDisplay(), MxCommentLogicalToOdbc(), MxCommentMakeSearchTerms(), MxCommentNormalize(), MxCommentSet(), MxCommentSimilarity(), MxCommentSimilarityIdx(), MxCommentStandardize()
property MxUnitsSold as %Integer;
Measure: MxUnitsSold
Source: UnitsSold
Property methods: MxUnitsSoldDisplayToLogical(), MxUnitsSoldGet(), MxUnitsSoldGetStored(), MxUnitsSoldIsValid(), MxUnitsSoldLogicalToDisplay(), MxUnitsSoldNormalize(), MxUnitsSoldSet()

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 (%UserMxAmountSold on MxAmountOfSale) [Type = bitmap];
index (%UserMxUnitsSold on MxUnitsSold) [Type = bitmap];
index (Dx475620761 on Dx475620761) [Type = bitmap];
Index for fact 8.
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 6.
Index methods: DxCategoryViaProductGet(), DxCategoryViaProductGetObject(), DxCategoryViaProductGetObjectId(), DxCategoryViaProductGetStored(), DxCategoryViaProductGetSwizzled(), DxCategoryViaProductIsValid(), DxCategoryViaProductNewObject(), DxCategoryViaProductSet(), DxCategoryViaProductSetObject(), DxCategoryViaProductSetObjectId(), DxCategoryViaProductUnSwizzle()
index (DxChannel on DxChannel) [Type = bitmap];
Index for fact 11.
Index methods: DxChannelGet(), DxChannelGetObject(), DxChannelGetObjectId(), DxChannelGetStored(), DxChannelGetSwizzled(), DxChannelIsValid(), DxChannelNewObject(), DxChannelSet(), DxChannelSetObject(), DxChannelSetObjectId(), DxChannelUnSwizzle()
index (DxDateOfSaleFxDayMonthYear on DxDateOfSaleFxDayMonthYear) [Type = bitmap];
Index for fact 5.
Index methods: DxDateOfSaleFxDayMonthYearCompute(), DxDateOfSaleFxDayMonthYearDisplayToLogical(), DxDateOfSaleFxDayMonthYearGet(), DxDateOfSaleFxDayMonthYearIsValid(), DxDateOfSaleFxDayMonthYearLogicalToDisplay(), DxDateOfSaleFxDayMonthYearLogicalToOdbc(), DxDateOfSaleFxDayMonthYearNormalize(), DxDateOfSaleFxDayMonthYearSQLCompute()
index (DxDateOfSaleFxMonthYear on DxDateOfSaleFxMonthYear) [Type = bitmap];
Index for fact 4.
Index methods: DxDateOfSaleFxMonthYearCompute(), DxDateOfSaleFxMonthYearDisplayToLogical(), DxDateOfSaleFxMonthYearGet(), DxDateOfSaleFxMonthYearIsValid(), DxDateOfSaleFxMonthYearLogicalToDisplay(), DxDateOfSaleFxMonthYearLogicalToOdbc(), DxDateOfSaleFxMonthYearNormalize(), DxDateOfSaleFxMonthYearSQLCompute()
index (DxDateOfSaleFxYear on DxDateOfSaleFxYear) [Type = bitmap];
Index for fact 3.
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 (DxDiscountRg857767687 on DxDiscountRg857767687) [Type = bitmap];
Index for fact 12.
Index methods: DxDiscountRg857767687Get(), DxDiscountRg857767687GetObject(), DxDiscountRg857767687GetObjectId(), DxDiscountRg857767687GetStored(), DxDiscountRg857767687GetSwizzled(), DxDiscountRg857767687IsValid(), DxDiscountRg857767687NewObject(), DxDiscountRg857767687Set(), DxDiscountRg857767687SetObject(), DxDiscountRg857767687SetObjectId(), DxDiscountRg857767687UnSwizzle()
index (DxNameViaCountryViaOutlet on DxNameViaCountryViaOutlet) [Type = bitmap];
Index for fact 9.
Index methods: DxNameViaCountryViaOutletGet(), DxNameViaCountryViaOutletGetObject(), DxNameViaCountryViaOutletGetObjectId(), DxNameViaCountryViaOutletGetStored(), DxNameViaCountryViaOutletGetSwizzled(), DxNameViaCountryViaOutletIsValid(), DxNameViaCountryViaOutletNewObject(), DxNameViaCountryViaOutletSet(), DxNameViaCountryViaOutletSetObject(), DxNameViaCountryViaOutletSetObjectId(), DxNameViaCountryViaOutletUnSwizzle()
index (DxOutlet on DxOutlet) [Type = bitmap];
Index for fact 10.
Index methods: DxOutletGet(), DxOutletGetObject(), DxOutletGetObjectId(), DxOutletGetStored(), DxOutletGetSwizzled(), DxOutletIsValid(), DxOutletNewObject(), DxOutletSet(), DxOutletSetObject(), DxOutletSetObjectId(), DxOutletUnSwizzle()
index (DxProduct on DxProduct) [Type = bitmap];
Index for fact 7.
Index methods: DxProductGet(), DxProductGetObject(), DxProductGetObjectId(), DxProductGetStored(), DxProductGetSwizzled(), DxProductIsValid(), DxProductNewObject(), DxProductSet(), DxProductSetObject(), DxProductSetObjectId(), DxProductUnSwizzle()
index (DxUnitsSold on DxUnitsSold) [Type = bitmap];
Index for fact 13.
Index methods: DxUnitsSoldGet(), DxUnitsSoldGetObject(), DxUnitsSoldGetObjectId(), DxUnitsSoldGetStored(), DxUnitsSoldGetSwizzled(), DxUnitsSoldIsValid(), DxUnitsSoldNewObject(), DxUnitsSoldSet(), DxUnitsSoldSetObject(), DxUnitsSoldSetObjectId(), DxUnitsSoldUnSwizzle()
index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
index (Mx1094836251B on Mx1094836251B) [Type = bitmap];
Index for fact M3.
Index methods: Mx1094836251BDisplayToLogical(), Mx1094836251BGet(), Mx1094836251BGetStored(), Mx1094836251BIsValid(), Mx1094836251BLogicalToDisplay(), Mx1094836251BNormalize(), Mx1094836251BSet()
index (MxAmountOfSale on MxAmountOfSale) [Type = bitslice];
Index for measure M1.
Index methods: MxAmountOfSaleDisplayToLogical(), MxAmountOfSaleExists(), MxAmountOfSaleGet(), MxAmountOfSaleGetStored(), MxAmountOfSaleIsValid(), MxAmountOfSaleLogicalToDisplay(), MxAmountOfSaleNormalize(), MxAmountOfSaleSet()
index (MxComment on MxComment(KEYS)) [Type = bitmap];
Index for measure M4.
Index methods: MxCommentBuildValueArray(), MxCommentChooseSearchKey(), MxCommentCreateQList(), MxCommentDisplayToLogical(), MxCommentGet(), MxCommentGetStored(), MxCommentIsValid(), MxCommentLogicalToDisplay(), MxCommentLogicalToOdbc(), MxCommentMakeSearchTerms(), MxCommentNormalize(), MxCommentSet(), MxCommentSimilarity(), MxCommentSimilarityIdx(), MxCommentStandardize()
index (MxUnitsSold on MxUnitsSold) [Type = bitslice];
Index for measure M2.
Index methods: MxUnitsSoldDisplayToLogical(), MxUnitsSoldExists(), MxUnitsSoldGet(), MxUnitsSoldGetStored(), MxUnitsSoldIsValid(), MxUnitsSoldLogicalToDisplay(), MxUnitsSoldNormalize(), MxUnitsSoldSet()
index (MxUnitsSoldSearch on MxUnitsSold) [Type = bitmap];
Search index for fact M2.

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: CacheStorage (HoleFoods.Cube.Fact)

^DeepSee.Fact("HOLEFOODS.CUBE.FACT")(ID)
 =
%sourceId
DxDateOfSale
DxCategoryViaProduct
DxProduct
Dx475620761
DxNameViaCountryViaOutlet
DxOutlet
DxChannel
DxDiscountRg857767687
DxUnitsSold
MxAmountOfSale
MxUnitsSold
Mx1094836251B
MxComment
FeedbackOpens in a new tab