ssas.model_json_3122_tables_measures_expressions_multiline - V

type: V ( view ), modify_date: 2021-11-24 17:34:41

RepoObject_guid: E2F27B65-9D0F-EC11-8518-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.model_json_3122_tables_measures_expressions_multiline

Columns

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

nvarchar(128)

NOT NULL

Key

nvarchar(4000)

NOT NULL

uniqueidentifier

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(500)

NOT NULL

nvarchar(128)

NOT NULL

tinyint

NOT NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_3122_tables_measures_expressions_multiline

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_3122_tables_measures_expressions_multiline

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_3122_tables_measures_expressions_multiline

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_3122_tables_measures_expressions_multiline

Column Reference Diagram

entity_1_1_colref-ssas.model_json_3122_tables_measures_expressions_multiline

Indexes

idx_model_json_3122_tables_measures_expressions_multiline__1

idx_model_json_3122_tables_measures_expressions_multiline__2

idx_model_json_3122_tables_measures_expressions_multiline__3

idx_model_json_3122_tables_measures_expressions_multiline__4

Column Details

_

databasename

databasename

nvarchar(128)

NOT NULL

Key

Key

nvarchar(4000)

NOT NULL

Measure_guid

Measure_guid

uniqueidentifier

NOT NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

tables_measures_name

tables_measures_name

nvarchar(500)

NOT NULL

tables_name

tables_name

nvarchar(128)

NOT NULL

Type

Type

tinyint

NOT NULL

Value

Value

nvarchar(max)

NULL

sql_modules_definition

ssas.model_json_3122_tables_measures_expressions_multiline - V script
/*
Select
    Distinct
    j2.[Key]
  , j2.[value]
  , j2.Type
From
    ssas.[model_json_312_tables_measures_T] As T1
    Cross Apply OpenJson ( T1.tables_measures_expression_ja )
                --As j1
                --Cross Apply OpenJson ( j1.Value )
                                           As j2
order by
    j2.[Key]
Go
*/

create View ssas.model_json_3122_tables_measures_expressions_multiline
As
Select
    T1.databasename
  , T1.tables_name
  , T1.tables_measures_name
  , T1.RepoObject_guid
  , T1.Measure_guid
  , j2.[Key]
  , j2.Value
  , j2.Type
From
    ssas.model_json_312_tables_measures_T As T1
    Cross Apply OpenJson ( T1.tables_measures_expression_ja )
                --As j1
                --Cross Apply OpenJson ( j1.Value )
                                          As j2