MDX + Trasnsactional Level
-
Hi, I would like to create a query that display the data on a transactional level with the related dimension on each row. I can acheive this using the DRILLTROUGH but it doesn't seem right as this is a top-level query and not a drill-trough. My query is DRILLTHROUGH MAXROWS 100 Select ([Measures].[ID]) on 0 From [NBOS] RETURN [Fact Trade].[ID] AS LiveTradeID,[Fact Trade].[Volume], [Fact Trade].[Total Volume],[Fact Trade].[Price], [Fact Trade].[Commission],[Fact Trade].[Commission2], [Fact Trade].[Trade Count],[$Company].[Company],[$Counterparty].[Company], [$Instrument].[Instrument Name], [$Sequence Item].[Sequence Item],[$Date Time].[Full Date Alternate Key] I looking for something similar to this SQL SELECT * FROM FactTrade INNER JOIN Instrument ON Instrument.InstrumentID = FactTrade.InstrumentID Does anyone know the best practice to do this. THANKS SO MUCH IN ADVANCE