Upload data from excel file into tm1 cube via TI process

Post Reply
Nissy
Posts: 2
Joined: Thu Apr 02, 2020 3:42 pm
OLAP Product: cognos tm1
Version: 2.0.9
Excel Version: 2016

Upload data from excel file into tm1 cube via TI process

Post 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.
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

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

Post by Wim Gielis »

For data, only the fine level of detail is needed.
For metadata (dimensions and their elements) you need all 3 columns.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply