COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: Sam2011 on 06 Jul 2011 09:22:16 AM

Title: Budget Vs Actual
Post by: Sam2011 on 06 Jul 2011 09:22:16 AM
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

Title: Re: Budget Vs Actual
Post by: MFGF on 06 Jul 2011 11:04:23 AM
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.
Title: Re: Budget Vs Actual
Post by: Sam2011 on 06 Jul 2011 01:36:29 PM
Thanks a lot - I will give it a try.