Untitled
unknown
plain_text
4 months ago
1.5 kB
3
Indexable
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].[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-12-03] 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
Editor is loading...
Leave a Comment