Location, Customer (MTD, Last Yr MTD, YTD, Last Yr YTD, QTD, Last Yr YTD) with MDX and Cube

Question

Hi,

Is it possible to build a report without using MDX and cube

for  

                                                     MTD, Last Yr MTD, YTD, Last Yr YTD, QTD, Last Yr YTD

Location (Lv1), Customer (Lv2)  

The table contain: Location, Customer, Sales Date, Price fields

Thank you!

Joe

Answer 1

Yes. You can always get data from the datawarehouse using standard SQL.

---

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog