Untitled

SELECT
  NON EMPTY Crossjoin(
    [Dates].[Date].[AsOfDate].Members,
    Hierarchize(
      [Risk].[Scenario Sets].[Scenario Set].Members
    ),
    Hierarchize(
      DrilldownLevel(
        [Portfolio].[TradingDesk].[ALL].[AllMember]
      )
    ),
    [Portfolio].[Portfolio].[Portfolio].Members,
    [Risk].[Risk Classes].[RiskClass].Members,
    [Risk].[Scenarios].[Scenario].Members
  ) ON ROWS,
  NON EMPTY [Measures].[PnLVectorExpand] ON COLUMNS
  FROM (
    SELECT
    [Risk].[Scenario Sets].[Scenario Set].[VAR_HISTORICAL_PL_HISTORICAL_1D] ON COLUMNS
    FROM (
      SELECT
      [Dates].[Date].[AsOfDate].[2024-11-22] 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 VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS