repo.RepoSchema_ssas_src - V
type: V ( view ), modify_date: 2021-11-16 12:01:41
RepoObject_guid: 52CA43F5-1F07-EC11-8515-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_RepoSchema_ssas_src
-
IndexSemanticGroup: no_group
-
[column-RepoSchema_name]; nvarchar(128)
-
-
PK, Unique, Real: 1, 1, 0
Column Details
_
sql_modules_definition
repo.RepoSchema_ssas_src - V script
/*
ssas databasename is used as RepoSchema_name
*/
CREATE View repo.RepoSchema_ssas_src
As
Select
--PK: RepoSchema_name
RepoSchema_name = T1.databasename
, is_ssas = 1
, is_SysSchema_missing = 0
, RepoSchema_description = Coalesce ( T1.l2_description, T2.descriptions_StrAgg )
, SysSchema_name = T1.databasename
From
ssas.model_json_20 As T1
Left Join
ssas.model_json_2011_descriptions_StrAgg As T2
On
T2.databasename = T1.databasename