Untitled

SELECT
  NON EMPTY Crossjoin(
    [Dates].[Date].[AsOfDate].Members,
    Hierarchize(
      Union(
        DrilldownLevel([Portfolio].[TradingDesk].[TradingDesk].Members),  -- Miembros específicos de TradingDesk
        { ([Portfolio].[TradingDesk].[ALL].[AllMember]) }  -- Total a nivel TradingDesk
      )
    ),
    Hierarchize(
      Union(
        DrilldownLevel([Portfolio].[Portfolio].[Portfolio].Members),  -- Miembros específicos de Portfolio
        { ([Portfolio].[Portfolio].[ALL].[AllMember]) }  -- Total a nivel Portfolio
      )
    ),
    Hierarchize(
      [Risk].[Risk Classes].[RiskClass].Members
    ),
    [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