ssas.model_json_3612_perspectives_tables_hierarchies - V

/*
--get and check existing values

Select
    Distinct
    j2.[Key]
  , j2.Type
From
    ssas.model_json_361_perspectives_tables                    As T1
    Cross Apply OpenJson ( T1.perspectives_tables_hierarchies_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
ORDER BY
    j2.[Key]
  , j2.Type
Go

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

Select
    DISTINCT
    j2.*
From
    ssas.model_json_361_perspectives_tables                    As T1
    Cross Apply OpenJson ( T1.perspectives_tables_hierarchies_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
Where
    j2.[Key] = 'hierarchies'
GO
*/
Create View ssas.model_json_3612_perspectives_tables_hierarchies
As
Select
    T1.databasename
  , T1.perspectives_name
  , T1.perspectives_tables_name
  , j2.perspectives_tables_hierarchies_name
From
    ssas.model_json_361_perspectives_tables                    As T1
    Cross Apply OpenJson ( T1.perspectives_tables_hierarchies_ja ) As j1
    Cross Apply
    OpenJson ( j1.Value )
    With
    (
        perspectives_tables_hierarchies_name NVarchar ( 500 ) N'$.name'
    ) As j2