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

General Ledger Fact Table: Dimensional Model

Go down

General Ledger Fact Table: Dimensional Model Empty General Ledger Fact Table: Dimensional Model

Post  jldosil Tue Jul 10, 2012 8:42 am


I need some help on dimensional modeling.

We have a transactional fact table that contains the general ledger account movements of a big enterprise. The size of the table is 350.000.000 rows.

1;1;6000;SALES;D;1.000 €
1;2;4720;VAT;D; 180 €
1;3;4000;PROVIDER;H;-1.180 €

The users ask us to have reports like this:

1. Filter the movements of an account, for example the account 6000:
1;1;6000;SALES;D;1.000 €

2. Determine the amount filtered in base of the counterpart movements of the asset, i.e, the rest of the movements of the asset, in the example:

1;1;6000;SALES;D; 1.000 € ;4720;VAT;D; 180 €
1;1;6000;SALES;D; 1.000 € ;4000;PROVIDER;H;-1.180 €

¿How do you do that with a good perfomance?

The ways we think are:

1. Use a view, but the number of rows is very high.
2. Use the fact table like itself, and like a role of itself, but the perfomance is not good.

Thanks a lot.

Jose Dosil


Posts : 3
Join date : 2011-09-19

Back to top Go down

Back to top

- Similar topics

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