Untitled

SELECT NON EMPTY Crossjoin([Dates].[Date].[AsOfDate].Members, [Risk].[Risk Classes].[RiskClass].Members, Hierarchize(DrilldownLevel([Portfolio].[TradingDesk].[ALL].[AllMember])), Hierarchize(DrilldownLevel([Portfolio].[Portfolio].[ALL].[AllMember]))) ON ROWS, NON EMPTY [Measures].[HPL] ON COLUMNS 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