I am building a cube on top of Navision. The transaction table contains all transactions since the start with Navision (1 July 2003) on General Ledger Account level. For the Balance Sheet accounts, we have imported/inserted opening balance amounts.
For the calculation of a trial balance of the Profit and Loss accounts I can just SUM the transactions for the period and it gives me the result for the period. For the balance sheet however, I can only calculate the net change for the period but not
the ending balance for that period.
Does SSAS have some kind of function to calculation the amount since the first date entry? (in my case 1 July 2003) For the P&L for example I created a calculated measure by using the YTD function that gives me the SUM for January untill August, even if
I have selected only the month of August. It would be nice if SSAS had some kind of STD (start to date) function.
Or do you advise that I have SSIS insert an opening balance on 1 January for each General balance sheet account (if I would find out how to do that ;-)
View Complete Post