TM1 Forum

Hi,

Am new to TM1 am facing below issues while creating TM1 Cube

In my source (Excel) there is no data for salary column,While loading the same to target cube through TI process need to show popup saying 'No data for Sal column'.

In my excel elements are dipaying are rows instead of columns,If i want to load the same through TI process we need to convert Rows to columns...Please assist me how to do achieve this..
Eg:In Exccel

Ename
Sal
Year
So above the element should convert to columns then we can load elements....

Thanks
Sudheer

dwsudheer wrote:In my source (Excel) there is no data for salary column,While loading the same to target cube through TI process need to show popup saying 'No data for Sal column'.

If I understand it correctly, you will want to use the ItemReject function in TI to present a message whenever a certain column is empty.

dwsudheer wrote:In my excel elements are dipaying are rows instead of columns,If i want to load the same through TI process we need to convert Rows to columns...Please assist me how to do achieve this..
Eg:In Exccel

Ename
Sal
Year
So above the element should convert to columns then we can load elements....

As to the other question, you're making it much more difficult than it needs to be.
But if you don't have any control over the source file, you could use variables and counters to retrieve the data and metadata from the file.
Write to the cube whenever you have all data and metadata to correcly identify 1 cell in the cube, at the lowest level in every dimension (unless you write textual data).
In the Advanced > Data tab, capture the row contents of the file and store them in variables. Empty / refill the variables again after you write the value in the cube.
Be careful when data is missing...