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]
      )
    ),
    [Risk].[Risk Classes].[RiskClass].Members,
    Hierarchize(
      DrilldownLevel(
        [Product].[Family].[ALL].[AllMember]
      )
    ),
    Hierarchize(
      DrilldownLevel(
        [Product].[Group].[ALL].[AllMember]
      )
    ),
    Hierarchize(
      DrilldownLevel(
        [Product].[Type].[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-12-03] ON COLUMNS
    FROM (
      SELECT
      [Risk].[Scenario Sets].[Scenario Set].[VAR_HISTORICAL_PL_HISTORICAL_1D] ON COLUMNS
      FROM [VaR-ES Cube]
    )
  )
  CELL PROPERTIES BACK_COLOR, FONT_FLAGS, FORE_COLOR, FORMATTED_VALUE, VALUE