Balance Sheet Fact

View previous topic View next topic Go down

Balance Sheet Fact

Post  jk2015 on Thu Feb 11, 2016 5:42 am

Hi,

I need to deliver some balance sheet reporting from the warehouse. I current already have a GL Transaction fact, which holds data by GL Account, Posting Date, Reporting Date, Customer etc.

Is it best practice to build a new fact to deliver the balance sheet reporting?

My current thinking is that my GL Transaction fact will give the details of the actual postings and adjustments etc, by various slices. Then I was thinking of building a fact called "Account Balance" or something similar, which would hold the balances each day for each Balance Sheet account.

Is this the normal way to do it?

Thank you

jk2015

Posts : 7
Join date : 2015-01-06

View user profile

Back to top Go down

Re: Balance Sheet Fact

Post  ngalemmo on Tue Feb 16, 2016 6:05 pm

Usually there are two fact tables. One contains transaction level detail (the journal) and the other a snapshot of the GL. The snapshot is usually the current balance and net activity by fully qualified account (i.e. including stuff like project, cost center and other subdivisions) and fiscal period. I have not seen a daily account balance table. Usually the period balance and the transaction data can be integrated in a query to derive a specific day's balance if it was needed.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

periodic snapshot

Post  Sudip on Tue Mar 15, 2016 10:39 pm

May be look into periodic snapshot

Sudip

Posts : 5
Join date : 2016-02-16

View user profile

Back to top Go down

Re: Balance Sheet Fact

Post  Sponsored content


Sponsored content


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