Untitled

 avatar
unknown
plain_text
4 months ago
1.8 kB
3
Indexable
SELECT
  NON EMPTY Crossjoin(
    Hierarchize(
      [Dates].[Date].[AsOfDate].Members
    ),
    Hierarchize(
      [Risk].[Scenario Sets].[Scenario Set].Members
    ),
    Hierarchize(
      DrilldownLevel(
        [Portfolio].[TradingDesk].[ALL].[AllMember]
      )
    ),
    Hierarchize(
      DrilldownLevel(
        [Portfolio].[Portfolio].[ALL].[AllMember]
      )
    ),
    [Risk].[Risk Classes].[RiskClass].Members,
    Hierarchize(
      DrilldownLevel(
        [Product].[Family].[ALL].[AllMember]
      )
    ),
    Hierarchize(
      DrilldownLevel(
        [Product].[Group].[ALL].[AllMember]
      )
    ),
    Hierarchize(
      DrilldownLevel(
        [Product].[Type].[ALL].[AllMember]
      )
    ),
    {
      [Measures].[Parametric VaE],
      [Measures].[VaE 99],
      [Measures].[VaE 99 Values],
      [Measures].[VaE 99 Scenario Name(s)],
      [Measures].[Weighted VaE 99],
      [Measures].[Parametric VaR],
      [Measures].[VaR 99],
      [Measures].[VaR 99 Values],
      [Measures].[VaR 99 Scenario Name(s)],
      [Measures].[Weighted VaR 99],
      [Measures].[Tail VaR],
      [Measures].[Tail VaE]
    }
  ) ON ROWS
  FROM (
    SELECT
    [Dates].[Date].[AsOfDate].[2024-12-03] ON COLUMNS
    FROM (
      SELECT
      [Risk].[Scenario Sets].[Scenario Set].[VAR_STRESSED_PL_HISTORICAL_1D] ON COLUMNS
      FROM (
        SELECT
        {
          [Risk].[Risk Classes].[ALL].[AllMember].[ALL_RF],
          [Risk].[Risk Classes].[ALL].[AllMember].[FX],
          [Risk].[Risk Classes].[ALL].[AllMember].[IR]
        } ON COLUMNS
        FROM [VaR-ES Cube]
      )
    )
  )
  CELL PROPERTIES BACK_COLOR, FONT_FLAGS, FORE_COLOR, FORMATTED_VALUE, VALUE
Editor is loading...
Leave a Comment