Untitled

SELECT NON EMPTY Crossjoin(Hierarchize([Dates].[Date].[AsOfDate].Members), Hierarchize([Risk].[Scenario Sets].[Scenario Set].Members), Hierarchize(DrilldownLevel([Portfolio].[TradingDesk].[ALL].[AllMember])), Hierarchize(DrilldownLevel([Portfolio].[Portfolio].[ALL].[AllMember])), [Risk].[Risk Classes].[RiskClass].Members, Hierarchize(DrilldownLevel([Product].[Family].[ALL].[AllMember])), Hierarchize(DrilldownLevel([Product].[Group].[ALL].[AllMember])), Hierarchize(DrilldownLevel([Product].[Type].[ALL].[AllMember])), {[Measures].[ES 97.5], [Measures].[Weighted ES 97.5], [Measures].[ETG 97.5], [Measures].[Weighted ETG 97.5]}) ON ROWS FROM (SELECT [Dates].[Date].[AsOfDate].[2024-12-03] ON COLUMNS FROM (SELECT [Risk].[Scenario Sets].[Scenario Set].[VAR_STRESSED_PL_HISTORICAL_1D] ON COLUMNS FROM [VaR-ES Cube])) CELL PROPERTIES BACK_COLOR, FONT_FLAGS, FORE_COLOR, FORMATTED_VALUE, VALUE;