Help with TI

[AWILDE]

I am struggling to master Turbo Intergrator in TM1, I have been able to set up processors to load data via SQL however have not been able to set up a process to load from another cube. I am trying to load cash balances from a balance sheet cube into a detailed cash forecasting cube, and so far have the below built:

Buit the view to the Balance Sheet cube and linked in data source and have set the contents in the variables tab to other.

Intercompany String Group Other
V2 String Local Other
V3 String Closing Other
Scenario String Reporting Actual Other
V5 String Total Group Other
V6 String 13000 Other
String All FYs Other
Value Numeric 1000 Data

In advanced - data tab I have the following:

CellputN(value,'Receipts and Payments Manual',V2,Scenario,V5,'Actual Cash Balance',V7);
The above matches to the 5 dimensions in the Receipts and payments manual cube.

If anyone can let me know what I am doing wrong it would be helpful.

[Alan Kirk]

I am struggling to master Turbo Intergrator in TM1, I have been able to set up processors to load data via SQL however have not been able to set up a process to load from another cube. I am trying to load cash balances from a balance sheet cube into a detailed cash forecasting cube, and so far have the below built:

Buit the view to the Balance Sheet cube and linked in data source and have set the contents in the variables tab to other.

Intercompany String Group Other
V2 String Local Other
V3 String Closing Other
Scenario String Reporting Actual Other
V5 String Total Group Other
V6 String 13000 Other
String All FYs Other
Value Numeric 1000 Data

In advanced - data tab I have the following:

CellputN(value,'Receipts and Payments Manual',V2,Scenario,V5,'Actual Cash Balance',V7);
The above matches to the 5 dimensions in the Receipts and payments manual cube.

If anyone can let me know what I am doing wrong it would be helpful.

When you're manually coding a TI, all of the variables, including the value, should be set to Other (or Ignore, if you aren't using them). "Data" and the other options are only for the evil auto-generated code creations of the equally evil Maps tab.

[AWILDE]

Thanks for the quick response Alan. I have changed the variable to other however it is still not loading any data. Any other ideas?

[Alan Kirk]

Thanks for the quick response Alan. I have changed the variable to other however it is still not loading any data. Any other ideas?

Is there any data to load?

The easiest way to tell is to use an AsciiOutput (on the data tab) to spit each row out into a text file. If the text file ends up empty, you know that you don't have any data.

The most obvious trap? If the view that you're using as your source will include consolidations, make sure that you don't have the view defined so that consolidations are suppressed.

[AWILDE]

That is what I have missed all along I had skip consolidation values ticked.

Thanks for this Alan.