TM1 Forum

Hi,

I hope you can help!

I am new to TM1 and don't really know how the TI process work, although I have been able to import data successfully into a several cubes.

My issue:
I've built a cube with 7 dimensions where two of dimensions should be able to collect data i.e (Entity, Line of business, Month, Currency, Actuality, Measures and Accounts).

The .csv files has the data organised as follows only: (999 is the data)
January, Actual, USD, Commercial Property, GWP , Argentina, YTD, 999

After configuring the Variables, dimensions.... I press run and everything seems to be working well, in fact a I get a nice "Process Completed" message: D

When I open the cube I can see that the data has not been uploaded - "I check the TI process on the Cube section to make sure: 1st Accumulate Values under "Data Action" is ticked & "Zero Out Portion" is unticked.

I have check the "transaction log” for this particular Cube and it shows under "New Values" the data I was expecting to see in the cube, but still nothing on the cube.

I have changed the view, inter manual data to make sure the aggregation are working correctly and so forth... but still the data is not showing up...

Anyone has encounter this problem before?... It seems to be the cube that is wrong.... because:
-The .csv file has got the values
- The TI process is showing: Process Complete
- The Audit log report is showing the expected data under the "New data" column for that cube...

Many Thanks
Eddie Medina

Hi,

Are you able to post here the variable tab of your T.I. that may help people understand your T.I. a little better.

Hi,
Thanks for your respond,
Finally, I was able to get my data into the cube! ... I think the reason I couldn’t get it throught the first time was:
1) Some elements in the .csv file where “slightly” different from those contained in the cube, for example I had an element “Commercial Property “in the cube and “Commercial Group Property” in the .csv fie.

2) For some reason I was trying to include the measure dimension twice (2 different rows) in the TI variable tab, once as a “String” – “Element” and a second time as a “Data” – “Numerical”.

3) In the “Dimensions” tab, all the dimensions were set to “As is” under the Action tab, and I guess that’s why the TI process was showing the “Complete Successful” message.

I used Zeroviewout to remove all the data from the cube, ran the TI process and everything sheems to be working now.