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-15] ON COLUMNS FROM [VaR-ES Cube])) CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS