Untitled

SELECT
  NON EMPTY Crossjoin(
    [Dates].[Date].[AsOfDate].Members,
    Hierarchize(
      DrilldownLevel(
        [Portfolio].[TradingDesk].[ALL].[AllMember]
      )
    ),
    [Measures].[HPL]
  ) ON ROWS
  FROM (
    SELECT
    [Dates].[Date].[AsOfDate].[2024-11-15] ON COLUMNS
    FROM [PLCube]
    WHERE (
      [Currencies].[Currencies].[ALL].[AllMember].[EUR],
      [Countries].[Countries].[ALL].[AllMember].[PL],
      [MarketData].[MarketDataSets].[MarketDataSet].[ES]
    )
  )
  WHERE (
    [Currencies].[Currencies].[ALL].[AllMember].[EUR],
    [Countries].[Countries].[ALL].[AllMember].[PL],
    [MarketData].[MarketDataSets].[MarketDataSet].[ES]
  )
  CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS