Invalid Key Error

Post Reply
kkmk
Posts: 73
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Invalid Key Error

Post 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.
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Invalid Key Error

Post 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.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
kkmk
Posts: 73
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Re: Invalid Key Error

Post by kkmk »

Thanks Jim for your quick reply. Let me go through the posting.
kkmk
kkmk
Posts: 73
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Re: Invalid Key Error

Post 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
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Invalid Key Error

Post 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.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
kkmk
Posts: 73
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Re: Invalid Key Error

Post by kkmk »

Yes.. I got it. I have changed the order of my variables in the variables tab.

Thanks Jim.

kkmk
Post Reply