Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Financial Data Model

2 posters

Go down

Financial Data Model Empty Financial Data Model

Post  abacusdotcom 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.


Posts : 4
Join date : 2009-11-23

Back to top Go down

Financial Data Model Empty Re: Financial Data Model

Post  BoxesAndLines 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!

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

Back to top Go down

Back to top

- Similar topics

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