Untitled
unknown
plain_text
5 months ago
1.2 kB
4
Indexable
SELECT NON EMPTY Crossjoin( [Dates].[Date].[AsOfDate].Members, Hierarchize( Union( DrilldownLevel([Portfolio].[TradingDesk].[TradingDesk].Members), -- Miembros específicos de TradingDesk { ([Portfolio].[TradingDesk].[ALL].[AllMember]) } -- Total a nivel TradingDesk ) ), Hierarchize( Union( DrilldownLevel([Portfolio].[Portfolio].[Portfolio].Members), -- Miembros específicos de Portfolio { ([Portfolio].[Portfolio].[ALL].[AllMember]) } -- Total a nivel Portfolio ) ), Hierarchize( [Risk].[Risk Classes].[RiskClass].Members ), [Measures].[HPL] ) ON ROWS FROM ( SELECT [Dates].[Date].[AsOfDate].[2024-11-15] ON COLUMNS FROM [PLCube] WHERE ( [Currencies].[Currencies].[ALL].[AllMember].[EUR], [Countries].[Countries].[ALL].[AllMember].[PL], [MarketData].[MarketDataSets].[MarketDataSet].[ES] ) ) WHERE ( [Currencies].[Currencies].[ALL].[AllMember].[EUR], [Countries].[Countries].[ALL].[AllMember].[PL], [MarketData].[MarketDataSets].[MarketDataSet].[ES] ) CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS
Editor is loading...
Leave a Comment