Untitled

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]
      )
    ),
    Hierarchize(
      DrilldownLevel(
        [Product].[Family].[ALL].[AllMember]
      )
    ),
    Hierarchize(
      DrilldownLevel(
        [Product].[Group].[ALL].[AllMember]
      )
    ),
    Hierarchize(
      DrilldownLevel(
        [Product].[Type].[ALL].[AllMember]
      )
    ),
    Hierarchize(
      DrilldownLevel(
        [Risk].[Risk Classes].[ALL].[AllMember]
      )
    ),
    {
      [Measures].[ES 97.5],
      [Measures].[Weighted ES 97.5],
      [Measures].[ETG 97.5],
      [Measures].[Weighted ETG 97.5]
    }
  ) ON ROWS
  FROM (
    SELECT
    [Dates].[Date].[AsOfDate].[2024-11-15] 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