configT.SsasDmvTableImport - V

type: V ( view ), modify_date: 2021-10-02 13:23:34

RepoObject_guid: CFE6A70A-8A06-EC11-8515-A81E8446D5B0

Description

obsolet

defines, which SSAS DMV tables should be imported

Examples

Example 1. Usage
Merge config.SsasDmvTableImport As tgt
Using configT.SsasDmvTableImport As src
On tgt.DmvTableName = src.DmvTableName
When Matched And tgt.isActive <> src.isActive
    Then Update Set
             isActive = src.isActive
When Not Matched By Target
    Then Insert
         (
             DmvTableName
           , isActive
         )
         Values
             (
                 src.DmvTableName
               , src.isActive
             );

Entity Diagram

entity-configt.ssasdmvtableimport

Columns

Table 1. Columns of configT.SsasDmvTableImport - V
PK Column Name Data Type NULL? ID

nvarchar(128)

NULL

bit

NULL

Foreign Key Diagram

entity_1_1_fk-configt.ssasdmvtableimport

References

Object Reference Diagram - 1 1

entity_1_1_objectref-configt.ssasdmvtableimport

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-configt.ssasdmvtableimport

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-configt.ssasdmvtableimport

Column Reference Diagram

entity_1_1_colref-configt.ssasdmvtableimport

Column Details

_

DmvTableName

DmvTableName

nvarchar(128)

NULL

isActive

isActive

bit

NULL

sql_modules_definition

configT.SsasDmvTableImport - V script
/*
<<property_start>>Description
obsolet

defines, which SSAS DMV tables should be imported
<<property_end>>

<<property_start>>exampleUsage
Merge config.SsasDmvTableImport As tgt
Using configT.SsasDmvTableImport As src
On tgt.DmvTableName = src.DmvTableName
When Matched And tgt.isActive <> src.isActive
    Then Update Set
             isActive = src.isActive
When Not Matched By Target
    Then Insert
         (
             DmvTableName
           , isActive
         )
         Values
             (
                 src.DmvTableName
               , src.isActive
             );
<<property_end>>
*/
CREATE   View [configT].[SsasDmvTableImport]
As
--
Select
    DmvTableName = Cast('TMSCHEMA_ANNOTATIONS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_ATTRIBUTE_HIERARCHIES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
--import issues
Select
    DmvTableName = Cast('TMSCHEMA_CALCULATION_ITEMS' As NVarchar(128))
  , isActive     = Cast(0 As Bit)
Union All
--import issues
Select
    DmvTableName = Cast('TMSCHEMA_CALCULATION_GROUPS' As NVarchar(128))
  , isActive     = Cast(0 As Bit)
Union All
--type conversion required
--CStr([RefreshedTime]) as [RefreshedTime]
Select
    DmvTableName = Cast('TMSCHEMA_COLUMNS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_COLUMN_PERMISSIONS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_CULTURES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_DATA_SOURCES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_DETAIL_ROWS_DEFINITIONS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_EXPRESSIONS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
--import issues
Select
    DmvTableName = Cast('TMSCHEMA_FORMAT_STRING_DEFINITIONS' As NVarchar(128))
  , isActive     = Cast(0 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_EXTENDED_PROPERTIES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_HIERARCHIES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_KPIS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_LEVELS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_MEASURES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_MODEL' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_OBJECT_TRANSLATIONS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_PARTITIONS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_PERSPECTIVE_COLUMNS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_PERSPECTIVE_HIERARCHIES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_PERSPECTIVE_MEASURES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_PERSPECTIVE_TABLES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_PERSPECTIVES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
--import issues
Select
    DmvTableName = Cast('TMSCHEMA_QUERY_GROUPS' As NVarchar(128))
  , isActive     = Cast(0 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_RELATIONSHIPS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_ROLE_MEMBERSHIPS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_ROLES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_TABLES' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_TABLE_PERMISSIONS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)
Union All
Select
    DmvTableName = Cast('TMSCHEMA_VARIATIONS' As NVarchar(128))
  , isActive     = Cast(1 As Bit)