Importing TM1 cube data from an Excel pivot table

[beckerc]

Hi,

I'm new to TM1 and I'm hoping someone can offer some advice. We would like to take data from a very large excel spreadsheet that is in a pivot-table format. The data needs to go into a lookup cube in TM1 which can then be used in allocation rules.

The table maps units to departments in our organization and indicates what percentage of budget for each unit should role up to each department. The layout is like this:


Department 1 Department 2 Department 3
Unit A 1 0 0
Unit B 0 .5 .5
Unit C 0 1 0

The lookup cube in TM1 should end up looking like our Excel table. It's a large volume of data and the units and departments can change each year so copying and pasting the data into a view could be error-prone.

Is there a way to use the pivot table as a data source in a TI process to build the cube?

Thanks in advance,
Christine

[David Usherwood]

It's a while since I did a lot with pivot tables, since TM1 does the same job so much better, but I do recall that they are based on a flat table with the rollups in columns. Find that table, save it as a CSV file, and it will read into a TM1 cube easily and very, very quickly.