TM1 Forum

Hi,
I am having an issue feeding from 1 cube to another:
Finance Cube
Finance cube Rule:
Finance Cube feeders: Currency Cube
Currency Cube Rule:
Not applicable as rule sits in finance cube

Currency cube feeder: The only 2 dimensions in common are Year and Month.


Finance Cube dimensions:
Year, Month , Version, Entity, Department, Office, Tier, Customer Segment, GLAccount, Finance_m

Currency Cube dimensions:
Year, Month, Currency, CurrencyConvertTo, Currency_m

By reducing what I feed drastically to a single GLAccount N element it does feed. This feeder (entered in the Currency Cube) does feed through to the Finance cube: Any help would be greatly appreciated

Why would you feed from the Currency cube to the Finance Cube in the first place? What is the determining factor as to whether a specific account has an amount in Closing Rate - USD? Think about it.

Thanks for the quick reply

Data loaded into Dimension = Finance_m and Element = 'Amount'
These are base amounts / Local currency amounts
I then have a currency cube showing conversion from each base currency to USD (because different entities in different countries
So:
ZAR to USD
EUR to USD
etc.

For this reason I need to get the exchange rate at the particular Year and Month and convert my amount into USD.

I am feeding not to optimise but to actually get the DB('Currency', !Year, !Month, ATTRS('Entity', !Entity, 'BaseCurrency'), ATTRS('Finance_m', !Finance_m, 'Currency'), 'Closing Rate') to return a value and be fed at the moment it returns a zero and is not fed

You didn't answer my question. I asked why you feel the need to write a feeder statement in the Currency cube. That feeder statement is completely worthless and I can see that you don't understand what a feeder does. All a feeder does is place a one-bit marker in a cell that tells the TM1 consolidation algorithm not to skip it when consolidating along a dimension. It has no difference whatsoever to do with whether or not your currency conversion calculation is going to work. This feeder statement:

['Amount'] => ['Closing Rate USD'];

is all you need to insure that Closing Rate USD is fed, because if there is an Amount then the Closing Rate USD cell will be fed. Once again, feeder doesn't mean your calc will work, just that the cell won't be skipped when one of your other dimensions is consolidated. Have you used the Trace Calculation function in TM1 (right click on a Closing Rate - USD cell in a cube view where you would expect to see a converted amount) to see why it's not working?

Hi Tomok,
Thanks for your reply.
I have that feeder in my feeders (['Amount'] => ['Closing Rate USD'] - see my original post.
I have removed all feeders in my currency cube and see that the currency is pulling through anyway.

The issue ended up being in another part of the model

Thanks for your help

allangibbon wrote:I have that feeder in my feeders (['Amount'] => ['Closing Rate USD'] - see my original post.

I know, that's where I got it from. I was basically just telling you that that was all you needed.

allangibbon wrote: I have removed all feeders in my currency cube and see that the currency is pulling through anyway.

Proof that a feeder has nothing to do with whether an intercube reference returns a value.

allangibbon wrote: The issue ended up being in another part of the model

That's what I was trying to tell you.

Thanks again.