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
Turbo Integrator/Import data in a cube
-
Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
Re: Turbo Integrator/Import data in a cube
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.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
-
jstrygner
- MVP
- Posts: 195
- Joined: Wed Jul 22, 2009 10:35 pm
- OLAP Product: TM1
- Version: 9.5.2 FP3
- Excel Version: 2010
Re: Turbo Integrator/Import data in a cube
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
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