We are about to embark on modeling a financial reporting star schema (P&L,
B/S). I would greatly appreciate any pointers to web sites / books on the
Some of the requirements we need to satisfy include :
1. Time Series analysis - the ability to view MTD, QTD, YTD (as well as
PYTD - Prior YTD)
2. The ability to drill down from a GL account balance to the Journal
Entries that helped arrive at that balance
3. A wishlist item - The ability to drill down from the GL to the respective
Any help greatly appreciated.
BTW, is there any vendor independent data warehousing forum out there ?