TI Wizard Error: No. of Dimensions do not match...

[harrytm1]

Hi all,

I encountered an error while using TI to update dimension and import data at the same time.

Let's say the cube has 4 dimensions (3 dim + 1 measure dim). In the Variables tab, I select 3 variables as "element" under Contents column. I also select another variable as "Data". FYI, my source file is an Excel file which I connect through ODBC driver.

But when I move to the Map tab, an error message appears, telling me the number of dimensions do not match the number in the cube.

Earlier, I did another TI to update dim and import data from a flat file, and it works i.e. I only need to designate 3 variables as elements and 1 as data.

any idea how to overcome this problem? set up a new dummy variable?

[Marcus Scherer]

Harry,
check your TI script for the CellPutN section. For a 4 dim cube it should be something like

#****Begin: Generated Statements***
CellPutN(Value,'cubex',Dim1,Dim2,Dim3,Dim4);
#****End: Generated Statements****

You need to specify the element for the "measure dimension" as well. Your "measure dimension" is treated like the others inside TM1. But you need to be aware of the measure dimension only if you want to report on top of TM1 with BI tools that require the specification of the measure dimension (e.g. Cognos BI).

HTH,
M.