ssas.model_json_3411121_cultures_translations_model_tables_hierarchies_levels - V
type: V ( view ), modify_date: 2021-10-01 15:27:22
RepoObject_guid: 1009DA81-C322-EC11-8524-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_model_json_3411121_cultures_translations_model_tables_hierarchies_levels__1
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-cultures_name]; nvarchar(10)
-
-
PK, Unique, Real: 0, 0, 0
idx_model_json_3411121_cultures_translations_model_tables_hierarchies_levels__2
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-cultures_name]; nvarchar(10)
-
[column-cultures_translations_model_name]; nvarchar(500)
-
-
PK, Unique, Real: 0, 0, 0
idx_model_json_3411121_cultures_translations_model_tables_hierarchies_levels__3
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
cultures_translations_model_tables_hierarchies_levels_name
cultures_translations_model_tables_hierarchies_levels_name |
|
|
cultures_translations_model_tables_hierarchies_levels_translatedCaption
cultures_translations_model_tables_hierarchies_levels_translatedCaption |
|
|
cultures_translations_model_tables_hierarchies_name
cultures_translations_model_tables_hierarchies_name |
|
|
sql_modules_definition
ssas.model_json_3411121_cultures_translations_model_tables_hierarchies_levels - V script
/*
--get and check existing values
Select
Distinct
j2.[Key]
, j2.Type
From
ssas.model_json_341112_cultures_translations_model_tables_hierarchies As T1
Cross Apply OpenJson ( T1.cultures_translations_model_tables_hierarchies_levels_ja ) As j1
Cross Apply OpenJson ( j1.Value ) As j2
Order by
j2.[Key]
, j2.Type
Go
Select
T1.*
, j2.*
From
ssas.model_json_341112_cultures_translations_model_tables_hierarchies As T1
Cross Apply OpenJson ( T1.cultures_translations_model_tables_hierarchies_levels_ja ) As j1
Cross Apply OpenJson ( j1.Value ) As j2
Go
Select
j2.*
From
ssas.model_json_341112_cultures_translations_model_tables_hierarchies As T1
Cross Apply OpenJson ( T1.cultures_translations_model_tables_hierarchies_levels_ja ) As j1
Cross Apply OpenJson ( j1.Value ) As j2
Where
j2.[Key] = 'columns'
Select
j2.*
From
ssas.model_json_341112_cultures_translations_model_tables_hierarchies As T1
Cross Apply OpenJson ( T1.cultures_translations_model_tables_hierarchies_levels_ja ) As j1
Cross Apply OpenJson ( j1.Value ) As j2
Where
j2.[Key] = 'measures'
Go
*/
create View ssas.model_json_3411121_cultures_translations_model_tables_hierarchies_levels
As
Select
T1.databasename
, T1.cultures_name
, T1.cultures_translations_model_name
, T1.cultures_translations_model_tables_name
, T1.cultures_translations_model_tables_hierarchies_name
, j2.cultures_translations_model_tables_hierarchies_levels_name
, j2.cultures_translations_model_tables_hierarchies_levels_translatedCaption
From
ssas.model_json_341112_cultures_translations_model_tables_hierarchies As T1
Cross Apply OpenJson ( T1.cultures_translations_model_tables_hierarchies_levels_ja ) As j1
Cross Apply
OpenJson ( j1.Value )
With
(
cultures_translations_model_tables_hierarchies_levels_name NVarchar ( 128 ) N'$.name'
, cultures_translations_model_tables_hierarchies_levels_translatedCaption NVarchar ( 128 ) N'$.translatedCaption'
) As j2