Financial Data Model

View previous topic View next topic Go down

Financial Data Model

Post  abacusdotcom on Thu Jan 10, 2013 7:39 am

Good day good people.

Got a new project on me. It's generally based on financial reporting. Reports based on monthly MPR, APR, Profit and Loss (P n L) and Income statements. Need to get how I can model the OLAP aspect. Please Kindly share your idea. Thanks.

abacusdotcom

Posts : 4
Join date : 2009-11-23

View user profile

Back to top Go down

Re: Financial Data Model

Post  BoxesAndLines on Thu Jan 10, 2013 10:21 am

I would use transaction, snapshot, and accumulating snapshot facts. For dimensions, I would use type 1 and 2. I rarely have found the need for type 3's. Good luck!
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum