If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Budget Vs Actual

Started by Sam2011, 06 Jul 2011 09:22:16 AM

Previous topic - Next topic

Sam2011

Hi all,
My star Schema database consistes of organization,submission, Account, Region, Client as dimension tables and a finance fact table that record mtd,ytd balances at the lowest GL code.
The issue I am having is I was trying to use the same finance fact table to store the budget information, the budget data that I receive is at a higher level of the ACtual data. for example:

Finance Fact Table - Actual
GL      Description        MTD                YTD
1001 Domestic Travel  2,000$        8,000$
1002 International Travel 15,000   80,000

These 2 accounts rollup into account 1000 Travel (in the account dimension table)
The budget I receive is at  Account 1000 level let's say 25,000$ per month for both Domestic and International.
Spreading the budget to the lowest level is not required.
It is required to report on Act Vs Budget on the budget level  (i.e on account 1000).
I guess my question is how to resolve this issue of having the data on a different account level to report on Actual Vs Budget without the need to spread the budget to the lowest GL Level

Thanks a lot


MFGF

Hi,

You would need the budget information in a separate fact query subject, with a relationship linking it to the Account 1000 level in the Accounts dimension.  You would also need determinants on the Account dimension, with the Account 1000 level having the Group by option checked and being defined before the granular account level (with the unique option checked).

Best regards,

MF.
Meep!

Sam2011

Thanks a lot - I will give it a try.