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.
Invalid Key Error
- 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
Please see this post:
http://www.tm1forum.com/viewtopic.php?f=18&t=5284
It's an issue that has been reported to IBM.
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
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
Jim, I have gone through the notes. I did not understand what the PRA team coming to say.

kkmk





kkmk
- 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
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
Yes.. I got it. I have changed the order of my variables in the variables tab.
Thanks Jim.
kkmk
Thanks Jim.
kkmk