Skip to main content

%DeepSee.SQL.CatalogQueries

Class %DeepSee.SQL.CatalogQueries [ Owner = {_PUBLIC}, System = 4 ]

Methods​

GetCubesExecute​

ClassMethod GetCubesExecute(ByRef qHandle As %Binary, pIncludeUnsupported As %String(VALUELIST=",none,warning,error") = "warning") As %Status [ Internal ]

Retrieves a list of all cubes accessible through SQL, along with relevant metadata, including whether the cube has any features not supported through direct SQL access. These cubes can be excluded from the result through the pIncludeUnsupported parameter, which defaults to "warning", meaning only cubes that will definitely not work are excluded from the result.

GetCubesClose​

ClassMethod GetCubesClose(ByRef qHandle As %Binary) As %Status [ Internal, PlaceAfter = GetCubesExecute ]

GetCubesFetch​

ClassMethod GetCubesFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) As %Status [ Internal, PlaceAfter = GetCubesExecute ]

HasUnsupportedFeatures​

ClassMethod HasUnsupportedFeatures(pCubeName As %String, Output pUnsupportedFeatures, Output pSC As %Status = {$$$OK}) As %Boolean [ SqlName = HasUnsupportedFeatures, SqlProc ]

Checks if a cube or subject area uses features that are not supported by default through the SQL projections. For example, the presence of an %OnGetFilterSpec() method on the cube class may indicate certain runtime code is expected that cannot be guaranteed to run by direct SQL access.

GetUnsupportedFeaturesExecute​

ClassMethod GetUnsupportedFeaturesExecute(ByRef qHandle As %Binary, pCubeName As %String) As %Status [ Internal ]

GetUnsupportedFeaturesClose​

ClassMethod GetUnsupportedFeaturesClose(ByRef qHandle As %Binary) As %Status [ Internal, PlaceAfter = GetUnsupportedFeaturesExecute ]

GetUnsupportedFeaturesFetch​

ClassMethod GetUnsupportedFeaturesFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) As %Status [ Internal, PlaceAfter = GetUnsupportedFeaturesExecute ]

GetDimensionTablesExecute​

ClassMethod GetDimensionTablesExecute(ByRef qHandle As %Binary, pCubeName As %String) As %Status [ Internal ]

GetDimensionTablesClose​

ClassMethod GetDimensionTablesClose(ByRef qHandle As %Binary) As %Status [ Internal, PlaceAfter = GetDimensionTablesExecute ]

GetDimensionTablesFetch​

ClassMethod GetDimensionTablesFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) As %Status [ Internal, PlaceAfter = GetDimensionTablesExecute ]

GetDimensionColumnsExecute​

ClassMethod GetDimensionColumnsExecute(ByRef qHandle As %Binary, pTableName As %String) As %Status [ Internal ]

Retrieves a list of measures, dimensions, and relationships in a cube's fact table which are accessible through SQL.

GetDimensionColumnsClose​

ClassMethod GetDimensionColumnsClose(ByRef qHandle As %Binary) As %Status [ Internal, PlaceAfter = GetDimensionColumnsExecute ]

GetDimensionColumnsFetch​

ClassMethod GetDimensionColumnsFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) As %Status [ Internal, PlaceAfter = GetDimensionColumnsExecute ]

Fetch​

ClassMethod Fetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) As %Status [ Internal, Private ]

Close​

ClassMethod Close(ByRef qHandle) As %Status [ Internal, Private ]