MDX Level Counts #MDX #BI

gistfile1.txt

--Количество уровней иерархии
WITH
      MEMBER [Measures].[NumberOfLevels] AS
      [Territory].[Territories]. Levels.Count
SELECT
      [Measures].[NumberOfLevels] ON COLUMNS
     
FROM
      [FRGS]

--Общее количество дочерних элементов до определенного уровня
WITH MEMBER [Measures].[ACount] AS
        COUNT(DESCENDANTS ([Territory].[Territories].CurrentMember,4))
SELECT [Measures].[ACount] ON 0
, {[Territory].[Territories].&[200001]} ON 1
FROM [FRGS]