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])), Hierarchize(DrilldownLevel([Product].[Family].[ALL].[AllMember])), Hierarchize(DrilldownLevel([Product].[Group].[ALL].[AllMember])), Hierarchize(DrilldownLevel([Product].[Type].[ALL].[AllMember])), Hierarchize(DrilldownLevel([Risk].[Risk Classes].[ALL].[AllMember])), {[Measures].[Parametric VaE], [Measures].[VaE 99], [Measures].[VaE 99 Values], [Measures].[VaE 99 Scenario Name(s)], [Measures].[Weighted VaE 99], [Measures].[Parametric VaR], [Measures].[VaR 99], [Measures].[VaR 99 Values], [Measures].[VaR 99 Scenario Name(s)], [Measures].[Weighted VaR 99]}) ON ROWS FROM (SELECT [Dates].[Date].[AsOfDate].[2024-11-15] ON COLUMNS FROM (SELECT [Risk].[Scenario Sets].[Scenario Set].[VAR_HISTORICAL_PL_HISTORICAL_1D] ON COLUMNS FROM [VaR-ES Cube])) CELL PROPERTIES BACK_COLOR, FONT_FLAGS, FORE_COLOR, FORMATTED_VALUE, VALUE