Page 1 of 1

Upload data from excel file into tm1 cube via TI process

Posted: Thu Apr 02, 2020 4:36 pm
by Nissy
Hi,

I have to create a cube and its dimensions and load an Excel file in this cube.

The file contains many columns and I have to compile the dimensions from this file.

My question is as follows: i have 3 columns which will be gathered under the same dimension (a fine level and 2 consolidated levels).

How can i do to uplode the data of this file in the cube? should i leave that fine levels and remove the consolidated columns?

Looking forward for your valuable suggestions.Thanks in advance.

Re: Upload data from excel file into tm1 cube via TI process

Posted: Thu Apr 02, 2020 4:55 pm
by Wim Gielis
For data, only the fine level of detail is needed.
For metadata (dimensions and their elements) you need all 3 columns.