Sample Financial Reports for Adventureworks (Updated)

I updated my AdventureWorks Sample Report to include CashFlow, so we now have the three core areas of GL in one PBIX. Profit and LossBalance SheetCash Flow You can download the PBIX from below link https://1drv.ms/u/s!Aquy5jaDyEyihsVDWoQ9TKyGRzwWSA?e=O4VkYr You can also download the source files from below linkhttps://prodata365-my.sharepoint.com/:u:/g/personal/bob_prodata_ie/EVnrkBMz0atFqswf16Pe6uUB3FHm_qcjDFVnJvop9LaTrA?e=n8du0z To see my sessions on Creating Financial Reports in … Continue reading Sample Financial Reports for Adventureworks (Updated)

Capturing a Service Side Trace for MDX<

When you need to do load testing for Analysis Services its common to need to capture and “replay” MDX queries. I’ll go into replay tools later – the first step is to capture the queries. You will need An XMLA trace definition file capturing at a minimum the QueryBegin and QueryEnd events (Events 9 and … Continue reading Capturing a Service Side Trace for MDX<