Hello,
My problem is this, Account 1000 is the only child of 2000. But because 2000 is an equity account, the value needs to be 1000*(-1).
Essentially it looks like this
Account Value
2000 -1000
1000 1000
Do I fix this problem in the rules section ? Please help!!
Balance Sheet and PL problem
-
- Posts: 52
- Joined: Thu May 15, 2008 9:11 am
- OLAP Product: Planning Analytics
- Version: IBM SaaS - Digital Pack
- Excel Version: Office 365
- Location: Reading / London
- Contact:
Re: Balance Sheet and PL problem
There's a much easier solution than rules - in Dimension Editor, right click on the '1000' element and under Element Properties, change the element weighting to -1
- Steve Rowe
- Site Admin
- Posts: 2416
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Balance Sheet and PL problem
If the way you have written your numbers down is how they are now then you already have the weighting set to -1 but you want to get the value against acc 1000 = -1000
Two ways
1.Load your values into a element called "Ledger Values", have another element in the same dimension called "Reporting Values" where you multiply the ledger values by plus or minus 1.
or
2.Apply a plus or minus 1 multiplier to the values on the way into the system.
Only do 2 if you have don't have the space in your cube to do 1 or you can't rebuild your ledger cube. The 2nd approach has some big disadvantages, since the signage has been messed around with you won't be able to get a trial balance from the system and so won't be able to prove that your data set is correct. Also if you have a new account in your load you probably won't know what multiplier to apply.
The last piece of the puzzle is how to get the multiplier. This is usually done using a ruled a attribute using the ElIsAnc formula to decide if an element is a certain part of the chart of accounts.
HTH
Steve
Two ways
1.Load your values into a element called "Ledger Values", have another element in the same dimension called "Reporting Values" where you multiply the ledger values by plus or minus 1.
or
2.Apply a plus or minus 1 multiplier to the values on the way into the system.
Only do 2 if you have don't have the space in your cube to do 1 or you can't rebuild your ledger cube. The 2nd approach has some big disadvantages, since the signage has been messed around with you won't be able to get a trial balance from the system and so won't be able to prove that your data set is correct. Also if you have a new account in your load you probably won't know what multiplier to apply.
The last piece of the puzzle is how to get the multiplier. This is usually done using a ruled a attribute using the ElIsAnc formula to decide if an element is a certain part of the chart of accounts.
HTH
Steve
Technical Director
www.infocat.co.uk
www.infocat.co.uk