Page 1 of 1

Invalid Key Error

Posted: Wed Jan 25, 2012 3:10 pm
by kkmk
I have a sales mix cube that populates through a TI process. The data source for the TI process is a TM1 View. Couple of days back, I have changed my view (not deleted/modified dimensions or elements).

After the view change, whenever I am executing TI process, it shows an error in error log file for all the rows.
"Region1","2008","Actual","100.",Data Source line (1) Error: Data procedure line (9): Invalid key: Dimension Name: "zz_Sales Mix", Element Name (Key): "Actual"

1. What could be the reason for this error?
2. How can we prevent this error?

Any Idea?

kkmk.

Re: Invalid Key Error

Posted: Wed Jan 25, 2012 3:13 pm
by jim wood
Please see this post:

http://www.tm1forum.com/viewtopic.php?f=18&t=5284

It's an issue that has been reported to IBM.

Re: Invalid Key Error

Posted: Wed Jan 25, 2012 3:14 pm
by kkmk
Thanks Jim for your quick reply. Let me go through the posting.
kkmk

Re: Invalid Key Error

Posted: Wed Jan 25, 2012 3:32 pm
by kkmk
Jim, I have gone through the notes. I did not understand what the PRA team coming to say.

:x :x :x :x :x

kkmk

Re: Invalid Key Error

Posted: Wed Jan 25, 2012 3:35 pm
by jim wood
Basically it's na issue where the view order changes. To work around it changed the order of my variables in the variables tab by renaming them.

Re: Invalid Key Error

Posted: Wed Jan 25, 2012 3:38 pm
by kkmk
Yes.. I got it. I have changed the order of my variables in the variables tab.

Thanks Jim.

kkmk