pauldatos wrote:Hi guys,
I am new here in TM1 Cognos and still a newbie. I found a problem that you can surely solve, please help me.
Not without you following the
Request for assistance guidelines (PLEASE READ) we can't, no.
For instance:
4) Similarly if you're getting unexpected results, specifics of what you're running, how, and what results you're getting will yield a more valuable response than "I'm running a T.I. but my code doesn't work properly". If you're getting an error, please be specific about what the error is (full details, not just "a runtime error" or "process terminated with errors"), and the circumstances under which it's occurring.
You've given no indication of HOW you are attempting to write that data to the cube. Are you using DBS formulas? DBSW? Saving the file as text and uploading it through a TI process? Something else?
6) Give a brief outline of what you've done to find the answer; which manuals or guides you've looked in, what tests you've done.
Have you checked that all of the elements that you're trying to write to are at N level? If so, how?
If you're using DBS/DBSW formulas, have you checked that the formulas are valid? If so, how? Have you downloaded
TM1 Tools and used the formula tracer? Have you checked that all of the arguments are valid elements?
On which point, looking at your data grid I doubt that they are. Arguments to any DBS formula (if that's what you're using) need to be strings representing element names. Column A appears to be pure Excel dates which will not translate into string element names unless you do an explicit conversion to text. (
ARE you doing and explicit conversion? Using which formula? Are you starting to see how much information is missing in your question?) To understand why Excel dates are not element names, see
here for a discussion of dates and times in TM1. Similarly "Day" and some of the other columns appear to be numeric values. Fine if they're data, most likely to cause a key error if they aren't.
Or to put it another way, "data, data, data, we cannot make bricks without clay".
