Page 1 of 1

Turbo Integrator/Import data in a cube

Posted: Mon Nov 15, 2010 4:01 pm
by Santiago
Hello everyone.
I have a question about turbo integrator. I want to import txt file data to a cube that is already created. The problem is that the txt data are based on 3 columns of the cube, but the other dimensions not listed in the txt. Therefore, when try to run the process appear the error: Wrong Number of dimension elements.
Anyone know what can I do?
Thanks

Re: Turbo Integrator/Import data in a cube

Posted: Mon Nov 15, 2010 4:18 pm
by Steve Vincent
Use TI to complete the missing info for you. For example, if one missing dimension is "scenario" and all the data is loaded to the same scenario, add a parameter that asks the user to enter the scenario when the TI is run.

Re: Turbo Integrator/Import data in a cube

Posted: Mon Nov 15, 2010 5:32 pm
by jstrygner
In TI on the 'Variables' tab you have probably four variables (three of them define dimension elements, one defines value you want to import to cube).

You can add remaining cube dimension(s) by clicking on the 'New Variable' button (on the right of variables grid), setting its name and value and define it as 'Element' as you (I assume) did in case of three dimensions you already had in your txt.

What you ask for is very basic way of importing data from a file to a cube so I also think you should be able to find enough hints in manuals.

HTH