TM1 Forum

While I'm bugging y'all with questions, I might as well go for broke. A thing that has been causing much grief for months involves data elments in TurboIntegrator. It goes like this:

1. Choose "Element" against each column of imported data that maps to a dimension, and "Data" against anything that maps to the 'measures' dimension.
2. Make all the Elements String type, and the Data one Numeric.
3. Go to the "Maps" tab and select a Dimension against each Element.

Now here's the problem: there should be a "Data Variables" item at the bottom of the table, against which the measure can be mapped. But often and for no logical reason I can deduce, the "Data Variables" item is missing. I have clicked all over the dialogs like a kind of mad thing, rebuilt the TI process from scratch, tried everything and it beats me. Sometimes it works, sometimes it doesn't.

Any ideas?

Regards,

Ian

Try making the elements numeric

I _think_ you only get the data variables option if you have more than data field in the datasource? I think that makes sense since if you have only 1 data field the wizard thinks that the data source is exactly the right 'shape' for the cube and so you don't need a data variables for the measure dimension.

To get round this add a new variable that explicitly says what the measure element is and set this to element.

As you're finding the wizard is quite limited and you'll want to start writing your own script at some point....

For John's point on making the elements numeric. This is a confusing area, if you are on the Variables tab then elements should be strings, if you are on the mapping tabs then elements should be of the numeric 'type'.

HTH

Cheers