TM1 Forum

Thanks for the help guys managed to get it working by referencing 'BalanceSheet' and 'P&L' (Rollups in the Rule cube) in the RHS of the feeder instead of the attribute mapping ! Thanks also for the CubeProcessFeeders tip as I will need to do this each time I redo the mappings

Regards Jon

Hi Lotsaram I have lots of issue's with this intercube rule mainly with the feeder, each time I edited the mappings for the accounts the feeder stopped working even if I unloaded both cubes etc. The current issue is that leaf to leaf mappings are fed ok but Consolidations to leafs are not working ev...

Pete thanks for your reply

[MI_Transaction_Currency:'USD']=N:

Works perfect well it did when I took out the typo ! !

Cheers

Hi David thanks for your comment however I have tried this several times, I have even edited the rule and unloaded both cubes but this did not work either

Regards Jon

I have 2 Dimensions with 'USD' and when I try and write a rule I get an error message saying I have an Ambiguous Element Name !
There must be away of identifying the dimension I want to reference in the right hand side of the rule ?

I have tried various ways including DB() etc

Regards Jon

I have built intercube rules that work fine however the intercube feeders seem to be patchy, if I hard code an individual account it feeds correctly however if I remove the hard coded account and select All Accounts it still only feeds the account I hard coded even though that feeder is not there ! ...

Hi Martin you were correct in thinking I had mapped the accounts only one way, reversed the mappings and the feeder worked first time, can't thank you enough for your help

Regards Jon

Hi Guys I have a rule which collects data from another cube via an attribute however I am having difficulty getting the feeder to work, not sure if it's my syntax or if I have forgotten a process when using intercube feeders. Vaguely remember being told to unload both cubes to get them to work or so...

Matt, Steve

Hi Guys

Created the new rollups without the balancing item in them and using Steve's feeder all works perfectly
Thanks very much have a virtual beer on me !

Regards jon

Steve many thanks for the reply, totaly agree with you on the false balancing item however this will only operate at a department level with further rules placing the unbalanced figure at a total company level. Tried you feeder suggestion but still getting #N/A's. Long shot but should the rollups fo...

Hi All 9.4 SP4 MS Excel 2003 I have written a rule that works perfectly, it acts as a balancing item in our Balance Sheet cube. The general contex is If the Absolute value of Assets are < than the Absolute value of Liabilities, place Assets Minus Liabilities in an Account that rolls up into Assets. ...