docs.RepoObject_MeasureList - V

type: V ( view ), modify_date: 2021-12-03 18:31:34

RepoObject_guid: 72E1C56A-C111-EC11-8519-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.repoobject_measurelist

Columns

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

1

uniqueidentifier

NULL

2

nvarchar(10)

NULL

nvarchar(max)

NULL

nvarchar(4000)

NULL

tinyint

NULL

nvarchar(max)

NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.repoobject_measurelist

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.repoobject_measurelist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.repoobject_measurelist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.repoobject_measurelist

Column Reference Diagram

entity_1_1_colref-docs.repoobject_measurelist

Indexes

PK_RepoObject_MeasureList

idx_RepoObject_MeasureList__2

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NULL

cultures_name

2

cultures_name

nvarchar(10)

NULL

AntoraMeasureDetails

AntoraMeasureDetails

nvarchar(max)

NULL

FilenameRelatedMeasures

FilenameRelatedMeasures

nvarchar(4000)

NULL

Description

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


is_external

is_external

tinyint

NULL

PlantumlMeasures

PlantumlMeasures

nvarchar(max)

NULL

RepoObject_DisplayName

RepoObject_DisplayName

nvarchar(128)

NULL

sql_modules_definition

docs.RepoObject_MeasureList - V script
CREATE View docs.RepoObject_MeasureList
As
Select
    rom.RepoObject_guid
  , rof.cultures_name
  , rof.RepoObject_DisplayName
  , rof.FilenameRelatedMeasures
  , is_external          = Max ( Cast(rof.is_external As TinyInt))
  , AntoraMeasureDetails =
  --
  String_Agg (
                 Concat (
                            --we need to convert to first argument nvarchar(max) to avoid the limit of 8000 byte
                            Cast('' As NVarchar(Max))
                          , Iif(transl.is_displayfolder = 1
                              , Concat (
                                           '[discrete]'
                                         , Char ( 13 ) + Char ( 10 )
                                         , '== '
                                         , docs.fs_cleanStringForHeader ( IsNull (
                                                                                     transl.displayfolder_DisplayName
                                                                                   , '_'
                                                                                 )
                                                                        )
                                         , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                                       )
                              , Concat (
                                           '[#measure-'
                                         , docs.fs_cleanStringForAnchorId ( transl.Measure_DisplayName )
                                         , ']'
                                         , Char ( 13 ) + Char ( 10 )
                                         , '=== '
                                         , docs.fs_cleanStringForHeader ( transl.Measure_DisplayName )
                                         , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                                         --, Case
                                         --      When transl.displayfolder_DisplayName <> ''
                                         --          Then
                                         --          Concat (
                                         --                     '.DisplayFolder: '
                                         --                   , Char ( 13 ) + Char ( 10 )
                                         --                   , '--'
                                         --                   , Char ( 13 ) + Char ( 10 )
                                         --                   , transl.displayfolder_DisplayName
                                         --                   , Char ( 13 ) + Char ( 10 )
                                         --                   , '--'
                                         --                   , Char ( 13 ) + Char ( 10 )
                                         --                   , Char ( 13 ) + Char ( 10 )
                                         --                 )
                                         --  End
                                         , '.Description'
                                         , Char ( 13 ) + Char ( 10 )
                                         , '--'
                                         , Char ( 13 ) + Char ( 10 )
                                         ----instead of {docname} use the _measures document
                                         --, '\include::partial$descriptiontags/{docname}.adoc[tag=description-measure-'
                                         , '\include::partial$descriptiontags/' + rof.FilenameRelatedMeasures
                                           + '.adoc[tag=description-measure-'
                                           + docs.fs_cleanStringForAnchorId ( transl.Measure_DisplayName )
                                           + ',opts=optional]'
                                         , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                                         , '//the following attribute could be set in the include above to enable or disable the usage of exported descriptions'
                                         , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                                         , 'ifndef::hide-exported-description-measure-'
                                           + docs.fs_cleanStringForAnchorId ( transl.Measure_DisplayName ) + '[]'
                                         , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                                         ----instead of {docname} use the _measures document
                                         --, '\include::partial$content/{docname}.adoc[tag=description-measure-'
                                         , '\include::partial$' + rof.FilenameRelatedMeasures
                                           + '.adoc[tag=description-measure-'
                                           + docs.fs_cleanStringForAnchorId ( transl.Measure_DisplayName )
                                           + ',opts=optional]'
                                         , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                                         , '\endif::hide-exported-description-measure-'
                                           + docs.fs_cleanStringForAnchorId ( transl.Measure_DisplayName ) + '[]'
                                         , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                                         , '--'
                                         , Char ( 13 ) + Char ( 10 )
                                         --add additional line to get more space
                                         , '{empty} +'
                                         , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                                         , Case
                                               When rom.Expression <> ''
                                                   Then
                                                   Concat (
                                                              '.Expression'
                                                            , Char ( 13 ) + Char ( 10 )
                                                            , '....'
                                                            , Char ( 13 ) + Char ( 10 )
                                                            , rom.Expression
                                                            , Char ( 13 ) + Char ( 10 )
                                                            , '....'
                                                            , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                                                          )
                                           End
                                         , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                                         --, mplist.MeasurePropertyList
                                         , mplist.MeasurePropertyTable
                                       )
                          --
                          )
                        )
               , Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                transl.displayfolder_DisplayName
                              , transl.is_displayfolder Desc
                              , transl.Measure_DisplayName)
  ----todo: some measures are in multiple displayfolders, but we need a measure only once. How to do? And how to get them in the right order?
  --, AntoraMeasureDescriptions          =
  ----
  --Iif(rof.RepoObject_DisplayName = '_measures'
  --  , 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.displayfolder_DisplayName
  --                                , transl.is_displayfolder Desc
  --                                , transl.Measure_DisplayName)
  --  , '')
  ----todo: some measures are in multiple displayfolders, but we need a measure only once. How to do? And how to get them in the right order?
  --, AntoraMeasureDescriptionTagContent =
  ----
  --Iif(rof.RepoObject_DisplayName = '_measures'
  --  , 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 descriptions' + 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.displayfolder_DisplayName
  --                                , transl.is_displayfolder Desc
  --                                , transl.Measure_DisplayName)
  --  , '')
  , PlantumlMeasures     =
  --
  String_Agg (
                 Concat (
                            Cast('' As NVarchar(Max))
                          , Iif(transl.is_displayfolder = 1
                              , Iif(transl.displayfolder_DisplayName <> ''
                                  , Concat (
                                               '  **'
                                             , docs.fs_cleanStringForPuml ( transl.displayfolder_DisplayName )
                                             , '**'
                                             , Char ( 13 ) + Char ( 10 )
                                           )
                                  , Null)
                              , Concat (
                                           '  ~ '
                                         , Iif(rom.measures_isHidden = 1, '<color:gray>', Null)
                                         , docs.fs_cleanStringForPuml ( transl.Measure_DisplayName )
                                         , Iif(rom.measures_isHidden = 1, ' (hidden)', Null)
                                         , Iif(rom.measures_isHidden = 1, '</color>', Null)
                                         , Char ( 13 ) + Char ( 10 )
                                       )
                          --
                          )
                        )
               , ''
             ) Within Group(Order By
                                transl.displayfolder_DisplayName
                              , transl.is_displayfolder Desc
                              , transl.Measure_DisplayName)
From
    repo.Measure_union                               As rom
    Left Outer Join
        docs.RepoObject_OutputFilter_T_gross         As rof
            On
            rom.RepoObject_guid        = rof.RepoObject_guid

    Left Join
        ssas.Measure_translation_displayfolder_union As transl
            On
            transl.Measure_guid        = rom.Measure_guid
            And transl.cultures_name   = rof.cultures_name
            And transl.RepoObject_name = rof.RepoObject_name

    Left Join
        docs.Measure_MeasurePropertyList             As mplist
            On
            mplist.Measure_guid        = rom.Measure_guid
--And mplist.cultures_name   = rof.cultures_name
Group By
    rom.RepoObject_guid
  , rof.cultures_name
  , rof.RepoObject_DisplayName
  , rof.FilenameRelatedMeasures