%DeepSee.SQL.CatalogQueries
class %DeepSee.SQL.CatalogQueries
Method Inventory
Methods
classmethod HasUnsupportedFeatures(pCubeName As %String, Output pUnsupportedFeatures, Output pSC As %Status = $$$OK) as %Boolean [ SQLProc = HasUnsupportedFeatures ]
Projected as the stored procedure: HasUnsupportedFeatures
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.
Queries
query GetCubes(pIncludeUnsupported As %String(VALUELIST=",none,warning,error")="none")
Selects ClassName As %String, CubeName As %String, DisplayName As %String, Type As %String, PackageName As %String, UnsupportedFeatures As %String
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.
query GetDimensionColumns(pTableName As %String)
Retrieves a list of measures, dimensions, and relationships in a cube's fact table which are accessible through SQL.
query GetDimensionTables(pCubeName As %String)
query GetUnsupportedFeatures(pCubeName As %String)