ssas.model_json_341113_cultures_translations_model_tables_measures - V

type: V ( view ), modify_date: 2021-10-01 15:22:21

RepoObject_guid: 1109DA81-C322-EC11-8524-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.model_json_341113_cultures_translations_model_tables_measures

Columns

Table 1. Columns of ssas.model_json_341113_cultures_translations_model_tables_measures - V
PK Column Name Data Type NULL? ID

nvarchar(10)

NOT NULL

nvarchar(500)

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(max)

NULL

nvarchar(512)

NULL

nvarchar(128)

NULL

nvarchar(128)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_341113_cultures_translations_model_tables_measures

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_341113_cultures_translations_model_tables_measures

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_341113_cultures_translations_model_tables_measures

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_341113_cultures_translations_model_tables_measures

Column Reference Diagram

entity_1_1_colref-ssas.model_json_341113_cultures_translations_model_tables_measures

Indexes

idx_model_json_341113_cultures_translations_model_tables_measures__1

idx_model_json_341113_cultures_translations_model_tables_measures__2

idx_model_json_341113_cultures_translations_model_tables_measures__3

Column Details

_

cultures_name

cultures_name

nvarchar(10)

NOT NULL

cultures_translations_model_name

cultures_translations_model_name

nvarchar(500)

NOT NULL

cultures_translations_model_tables_measures_name

cultures_translations_model_tables_measures_name

nvarchar(128)

NULL

cultures_translations_model_tables_measures_translatedCaption

cultures_translations_model_tables_measures_translatedCaption

nvarchar(128)

NULL

cultures_translations_model_tables_measures_translatedDescription

cultures_translations_model_tables_measures_translatedDescription

nvarchar(max)

NULL

cultures_translations_model_tables_measures_translatedDisplayFolder

cultures_translations_model_tables_measures_translatedDisplayFolder

nvarchar(512)

NULL

cultures_translations_model_tables_name

cultures_translations_model_tables_name

nvarchar(128)

NULL

databasename

databasename

nvarchar(128)

NOT NULL

sql_modules_definition

ssas.model_json_341113_cultures_translations_model_tables_measures - V script
/*
--get and check existing values

Select
    Distinct
    j2.[Key]
  , j2.Type
From
    ssas.model_json_34111_cultures_translations_model_tables                      As T1
    Cross Apply OpenJson ( T1.cultures_translations_model_tables_measures_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
Order by
    j2.[Key]
  , j2.Type
Go

Select
    T1.*
  , j2.*
From
    ssas.model_json_34111_cultures_translations_model_tables                      As T1
    Cross Apply OpenJson ( T1.cultures_translations_model_tables_measures_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
Go

Select
    j2.*
From
    ssas.model_json_34111_cultures_translations_model_tables                      As T1
    Cross Apply OpenJson ( T1.cultures_translations_model_tables_measures_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
Where
    j2.[Key] = 'columns'

Select
    j2.*
From
    ssas.model_json_34111_cultures_translations_model_tables                      As T1
    Cross Apply OpenJson ( T1.cultures_translations_model_tables_measures_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
Where
    j2.[Key] = 'measures'
Go

*/
Create   View ssas.model_json_341113_cultures_translations_model_tables_measures
As
Select
    T1.databasename
  , T1.cultures_name
  , T1.cultures_translations_model_name
  , T1.cultures_translations_model_tables_name
  , j2.cultures_translations_model_tables_measures_name
  , j2.cultures_translations_model_tables_measures_translatedCaption
  , j2.cultures_translations_model_tables_measures_translatedDescription
  , j2.cultures_translations_model_tables_measures_translatedDisplayFolder
From
    ssas.model_json_34111_cultures_translations_model_tables                   As T1
    Cross Apply OpenJson ( T1.cultures_translations_model_tables_measures_ja ) As j1
    Cross Apply
    OpenJson ( j1.Value )
    With
    (
        cultures_translations_model_tables_measures_name NVarchar ( 128 ) N'$.name'
      , cultures_translations_model_tables_measures_translatedCaption NVarchar ( 128 ) N'$.translatedCaption'
      , cultures_translations_model_tables_measures_translatedDescription NVarchar ( Max ) N'$.translatedDescription'
      , cultures_translations_model_tables_measures_translatedDisplayFolder NVarchar ( 512 ) N'$.translatedDisplayFolder'
    ) As j2