repo.RepoObject_SSAS_src - V

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

RepoObject_guid: 114559F6-0807-EC11-8515-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.repoobject_ssas_src

Columns

Table 1. Columns of repo.RepoObject_SSAS_src - V
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NOT NULL

int

NOT NULL

int

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

varchar(1)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

varchar(1)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.repoobject_ssas_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobject_ssas_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobject_ssas_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobject_ssas_src

Column Reference Diagram

entity_1_1_colref-repo.repoobject_ssas_src

Indexes

PK_RepoObject_SSAS_src

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL

is_repo_managed

is_repo_managed

int

NOT NULL

is_ssas

is_ssas

int

NOT NULL

Referencing Columns

RepoObject_name

RepoObject_name

nvarchar(128)

NOT NULL

RepoObject_schema_name

RepoObject_schema_name

nvarchar(128)

NOT NULL

RepoObject_type

RepoObject_type

varchar(1)

NOT NULL

SysObject_name

SysObject_name

nvarchar(128)

NOT NULL

SysObject_schema_name

SysObject_schema_name

nvarchar(128)

NOT NULL

SysObject_type

SysObject_type

varchar(1)

NOT NULL

sql_modules_definition

repo.RepoObject_SSAS_src - V script
/*
<<property_start>>Description
* converts xref:sqldb:ssas.model_json_31_tables_t.adoc[] into xref:sqldb:repo.repoobject.adoc[]
* one virtual table '_measures' is created per ssas schema from xref:sqldb:repo.reposchema.adoc[]
<<property_end>>
*/
CREATE View [repo].[RepoObject_SSAS_src]
As
Select
    --PK: RepoObject_guid
    T1.RepoObject_guid
  , is_repo_managed        = 1
  , is_ssas                = 1
  --, modify_dt              = ModifiedTime
  , RepoObject_name        = T1.tables_name
  , RepoObject_schema_name = T1.databasename
  , RepoObject_type        = 'U'
  ----ID could interfer with relational database id
  ----we could use only, if we have only ssas objects in the repo
  ----that's why it is better, not to use it
  --, SysObject_id           = ID
  --, SysObject_modify_date  = ModifiedTime
  , SysObject_name         = T1.tables_name
  , SysObject_schema_name  = T1.databasename
  , SysObject_type         = 'U'
From
    ssas.model_json_31_tables_T As T1
Union All
Select
    --PK: RepoObject_guid
    --[VirtualRepoObjekt_guid] is created per Schema to be used as additional RepoObject_guid
    RepoObject_guid        = T1.MeasuresRepoObjekt_guid
  , is_repo_managed        = 1
  , is_ssas                = 1
  --, modify_dt              = ModifiedTime
  , RepoObject_name        = T1.MeasuresRepoObjekt_name
  , RepoObject_schema_name = T1.RepoSchema_name
  , RepoObject_type        = 'U'
  ----ID could interfer with relational database id
  ----we could use only, if we have only ssas objects in the repo
  ----that's why it is better, not to use it
  --, SysObject_id           = ID
  --, SysObject_modify_date  = ModifiedTime
  , SysObject_name         = T1.MeasuresRepoObjekt_name
  , SysObject_schema_name  = T1.RepoSchema_name
  , SysObject_type         = 'U'
From
    repo.RepoSchema As T1
Where
    T1.is_ssas = 1