docs.RepoObject_MeasureDescriptionList - V

type: V ( view ), modify_date: 2021-12-03 18:30:57

RepoObject_guid: 84DC9176-B547-EC11-8530-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.repoobject_measuredescriptionlist

Columns

Table 1. Columns of docs.RepoObject_MeasureDescriptionList - V
PK Column Name Data Type NULL? ID

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(10)

NOT NULL

nvarchar(4000)

NULL

nvarchar(128)

NULL

uniqueidentifier

NULL

Foreign Key Diagram

entity_1_1_fk-docs.repoobject_measuredescriptionlist

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.repoobject_measuredescriptionlist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.repoobject_measuredescriptionlist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.repoobject_measuredescriptionlist

Column Reference Diagram

entity_1_1_colref-docs.repoobject_measuredescriptionlist

Indexes

idx_RepoObject_MeasureDescriptionList__1

Column Details

_

AntoraMeasureDescriptions

AntoraMeasureDescriptions

nvarchar(max)

NULL

AntoraMeasureDescriptionTagContent

AntoraMeasureDescriptionTagContent

nvarchar(max)

NULL

cultures_name

cultures_name

nvarchar(10)

NOT NULL

FilenameRelatedMeasures

FilenameRelatedMeasures

nvarchar(4000)

NULL

Description

(case when [is_ssas]=(1) then [docs].[fs_cleanStringForFilename]([RepoObject_schema_name]+'._measures') end)


RepoObject_DisplayName

RepoObject_DisplayName

nvarchar(128)

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NULL

sql_modules_definition

docs.RepoObject_MeasureDescriptionList - V script
/*
descriptions for measures are only entered once, in the RepoObject '_measures', containing all measures +
it should be also used by all other tables of tht ssas model
*/
CREATE View docs.RepoObject_MeasureDescriptionList
As
Select
    --PK: (FilenameRelatedMeasures, cultures_name)
    rof.FilenameRelatedMeasures
  , rof.cultures_name
  , rom.RepoObject_guid
  , rof.RepoObject_DisplayName
  , AntoraMeasureDescriptions          =
  --
  String_Agg (
                 Concat (
                            --we need to convert to first argument nvarchar(max) to avoid the limit of 8000 byte
                            Cast(N'' As NVarchar(Max))
                          , Char ( 13 ) + Char ( 10 )
                          , '=== '
                          , docs.fs_cleanStringForHeader ( transl.Measure_DisplayName )
                          , ' - description'
                          , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , '// tag::description-measure-'
                            + docs.fs_cleanStringForAnchorId ( transl.Measure_DisplayName ) + '[]'
                          , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , rom.Description
                          , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , '// end::description-measure-'
                            + docs.fs_cleanStringForAnchorId ( transl.Measure_DisplayName ) + '[]'
                        )
               , Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                transl.Measure_DisplayName)
  , AntoraMeasureDescriptionTagContent =
  --
  String_Agg (
                 Concat (
                            --we need to convert to first argument nvarchar(max) to avoid the limit of 8000 byte
                            Cast(N'' As NVarchar(Max))
                          , Char ( 13 ) + Char ( 10 )
                          , '=== '
                          , docs.fs_cleanStringForHeader ( transl.Measure_DisplayName )
                          , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , '// tag::description-measure-'
                            + docs.fs_cleanStringForAnchorId ( transl.Measure_DisplayName ) + '[]'
                          , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , '// uncomment the following attribute, to hide exported (by AntoraExport) descriptions. Keep the empty line on top of the attribute!'
                            + Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , '//:hide-exported-description-measure-'
                            + docs.fs_cleanStringForAnchorId ( transl.Measure_DisplayName ) + ':'
                          , Char ( 13 ) + Char ( 10 )
                          , '// end::description-measure-'
                            + docs.fs_cleanStringForAnchorId ( transl.Measure_DisplayName ) + '[]'
                        )
               , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                transl.Measure_DisplayName)
From
    repo.Measure_union                       As rom
    Inner Join
        docs.RepoObject_OutputFilter_T_gross As rof
            On
            rom.RepoObject_guid        = rof.RepoObject_guid

    Inner Join
        ssas.Measure_translation_T           As transl
            On
            transl.Measure_guid        = rom.Measure_guid
            And transl.cultures_name   = rof.cultures_name
            And transl.RepoObject_name = rof.RepoObject_name
Group By
    rom.RepoObject_guid
  , rof.cultures_name
  , rof.RepoObject_DisplayName
  , rof.FilenameRelatedMeasures
Having
    rof.RepoObject_DisplayName = '_measures'