Untitled
unknown
plain_text
5 months ago
1.2 kB
2
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].[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_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