How to load data in cube??

[jayanthhyd]

Hi guys i created cube in tm1 using TI from flat files and odbc.. after creation of cube i am not able to see measure's values.. can any one tell me clearly how to load measure values in to cube??? Thank you.

[dusherwo]

Have you set the relevant column of your data source as Data? If everything else has been done right then that's all you need. Note that loading multiple data columns can be done, but doing it with the wizard is somewhat quirky and I believe only works in recent versions.

[jayanthhyd]

"?Have you set the relevant column of your data source as Data??" I put 'data type' as 'data' for measures and 'element' for strings, consolidation for hirerarchy... And u saying about wizard i dont know about that.. At present i am using tm1 9.5.1.. please can u tell me in detail... Thanks for your reply..

[dusherwo]

I think you mean Contents not Data Type. You are probably using the wizard - if not you would set all columns as Other and write your own TI code.
On this basis - in Maps, have you specified the cube to send the data to? Have you got the right number of dimensions? (If not you can't save the TI.) If you have multiple data columns, have you specified which dimension is to be used for the data (can only be one) and what element each column should go to? If you have done all that, you should see the generated code in the Advanced Tab, Data subtab, with cellputn's to update your cube.

[jayanthhyd]

i got the result..