Untitled

SELECT
  NON EMPTY Crossjoin(
    [Dates].[Date].[AsOfDate].Members,
    [Risk].[Scenario Sets].[Scenario Set].Members,
    Hierarchize(
      DrilldownLevel(
        [Portfolio].[TradingDesk].[ALL].[AllMember]
      )
    ),
    Hierarchize(
      DrilldownLevel(
        [Portfolio].[Portfolio].[ALL].[AllMember]
      )
    ),
    Hierarchize(
      DrilldownLevel(
        [Risk].[Scenarios].[ALL].[AllMember]
      )
    ),
    [Ger PL - Limits].[(Lim) POLAND].[(Lim) POLAND].Members
  ) ON ROWS,
  NON EMPTY [Measures].[CleanPL BT] ON COLUMNS
  FROM (
    SELECT
    [Risk].[Scenario Sets].[Scenario Set].[CLEAN_PL_PL] ON COLUMNS
    FROM (
      SELECT
      [Dates].[Date].[AsOfDate].[2024-11-14] ON COLUMNS
      FROM [VaR-ES Cube]
    )
  )
  CELL PROPERTIES BACK_COLOR, FONT_FLAGS, FORE_COLOR, FORMATTED_VALUE, VALUE