configT.SsasDmv_ExplicitDataType - V

type: V ( view ), modify_date: 2021-08-27 13:39:08

RepoObject_guid: 9450DDF7-2B07-EC11-8515-A81E8446D5B0

Description

Examples

Entity Diagram

entity-configt.ssasdmv_explicitdatatype

Columns

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

int

NOT NULL

varchar(34)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-configt.ssasdmv_explicitdatatype

References

Object Reference Diagram - 1 1

entity_1_1_objectref-configt.ssasdmv_explicitdatatype

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-configt.ssasdmv_explicitdatatype

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-configt.ssasdmv_explicitdatatype

Column Reference Diagram

entity_1_1_colref-configt.ssasdmv_explicitdatatype

Column Details

_

ExplicitDataType

ExplicitDataType

int

NOT NULL

ExplicitDataTypeName

ExplicitDataTypeName

varchar(34)

NOT NULL

sql_modules_definition

configT.SsasDmv_ExplicitDataType - V script
/*
it is hard to find oficial source, I found something here:

https://www.biinsight.com/automate-testing-ssas-tabular-models/#more-5909

*/
Create   View configT.SsasDmv_ExplicitDataType
As
Select
    ExplicitDataType     = 2
  , ExplicitDataTypeName = 'String'
Union All
Select
    ExplicitDataType     = 6
  , ExplicitDataTypeName = 'Int64'
Union All
Select
    ExplicitDataType     = 8
  , ExplicitDataTypeName = 'Double'
Union All
Select
    ExplicitDataType     = 9
  , ExplicitDataTypeName = 'DateTime'
Union All
Select
    ExplicitDataType     = 10
  , ExplicitDataTypeName = 'Decimal'
Union All
Select
    ExplicitDataType     = 11
  , ExplicitDataTypeName = 'Boolean'
Union All
Select
    ExplicitDataType     = 17
  , ExplicitDataTypeName = 'Binary'
Union All
Select
    ExplicitDataType     = 19
  , ExplicitDataTypeName = 'Unknown (column is in Error state)'