I apologise for the rather convoluted long explanation, please bear with me.
I have started to develop my first cube that displays information about construction jobs. It will display financial data based on transactions that show cost of goods and sales invoices (this is the grain).
Each transaction is assigned a general Ledger code: materials are one GL code, labour is another etc. The transactions are against jobs. Each job has its own Job Reference number and each job can have several transactions against it.
There is a Period dimension that organises data into months (2010012, 2011001 etc). Each month, the finance dept manually add to the system, two specific journal entries for each job (these are GL codes that correspond to Cost of Sales (COS) and Turnover.
It's best if I leave some of the details out about these not to complicate things.
Here's where I'd like to ask advice.... The two journal entries - COS and turnover - that are applied to each month for each jobs show the full expenditure, turnover for each job so they’re already aggregated for each job. I believe these two codes
values are semi-additive!? The value£ of these type of GL codes can't be summed like the values of the other GL codes. For instance, if I wanted to see the total for each GL code for each proj
View Complete Post