About the tm1p.xla file in version 10.1
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
About the tm1p.xla file in version 10.1
Hi All:
I am a new here who want to learn the Cognos TM1 and our company has the version 10.1, but when I install the server and try to restart the Perspectives service, it faced the error "Compile error in hidden module"
Then how can I deal with it ? I analysis this problem is the VBA code error, so can anyone help me to transfer the tm1p.xla to me ? Or if my analysis is wrong , can anyone analysis my question? Thanks.
I am a new here who want to learn the Cognos TM1 and our company has the version 10.1, but when I install the server and try to restart the Perspectives service, it faced the error "Compile error in hidden module"
Then how can I deal with it ? I analysis this problem is the VBA code error, so can anyone help me to transfer the tm1p.xla to me ? Or if my analysis is wrong , can anyone analysis my question? Thanks.
Last edited by Aruis.yu on Thu Oct 23, 2014 11:02 am, edited 1 time in total.
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: About the tm1p.xla file in version 10.1
There have been lots of issues with MSCOMCTL.OCX either not being registered or old versions being registered.
Try downloading the latest copy and regsvring it in.
See http://www-01.ibm.com/support/docview.w ... wg21623762
Edit - and this http://www.tm1forum.com/viewtopic.php?f=3&t=8393
Try downloading the latest copy and regsvring it in.
See http://www-01.ibm.com/support/docview.w ... wg21623762
Edit - and this http://www.tm1forum.com/viewtopic.php?f=3&t=8393
Declan Rodger
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the tm1p.xla file in version 10.1
declanr wrote:There have been lots of issues with MSCOMCTL.OCX either not being registered or old versions being registered.
Try downloading the latest copy and regsvring it in.
See http://www-01.ibm.com/support/docview.w ... wg21623762
Edit - and this http://www.tm1forum.com/viewtopic.php?f=3&t=8393
Thanks a lot. But after I read the issue, the error still exist
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: About the tm1p.xla file in version 10.1
Which of the listed steps did you try?Aruis.yu wrote: Thanks a lot. But after I read the issue, the error still exist
Declan Rodger
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the tm1p.xla file in version 10.1
My office is 2010, as the resolving in the web you provided http://support.microsoft.com/kb/2597986 is the answer. But when I check the HKEY_CLASSES_ROOT\TypeLib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1} it doesn't in my regedit.msc. So I can't to this step.declanr wrote:Which of the listed steps did you try?Aruis.yu wrote: Thanks a lot. But after I read the issue, the error still exist
By the way did you have the skype for the easy communication or can you sent the email to me? My Email is ****************
Last edited by Aruis.yu on Thu Oct 23, 2014 10:51 am, edited 1 time in total.
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: About the tm1p.xla file in version 10.1
Because this is your personal, free Cognos support line?Aruis.yu wrote:By the way did you have the skype for the easy communication or can you sent the email to me? My Email is aruis.yu@analyticservice.net
Where do I sign up for an account?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the tm1p.xla file in version 10.1
Delete
Last edited by Aruis.yu on Thu Oct 23, 2014 10:57 am, edited 3 times in total.
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: About the tm1p.xla file in version 10.1
32 bit, or 64 bit? (File => Help in Excel.)Aruis.yu wrote:My office is 2010,declanr wrote:Which of the listed steps did you try?Aruis.yu wrote: Thanks a lot. But after I read the issue, the error still exist
Hint: Since you're on 10.1, if you're on Office 64 bit then don't expect the add-in to work.
As you've already found that kind of request won't get you a whole lot of sympathy. The forum is a group of TM1 users who are prepared to help each other out when they have time to, not a support line where someone is sitting on the other end of a Skype connection waiting for problems to be sent to them.Aruis.yu wrote:By the way did you have the skype for the easy communication or can you sent the email to me?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the tm1p.xla file in version 10.1
Alan Kirk wrote:
As you've already found that kind of request won't get you a whole lot of sympathy. The forum is a group of TM1 users who are prepared to help each other out when they have time to, not a support line where someone is sitting on the other end of a Skype connection waiting for problems to be sent to them.
Ok. Thanks for your mention and your answer, I think the guys here is very warm-heart.
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: About the tm1p.xla file in version 10.1
People are giving you help voluntarily out of their own time. The surest way to ensure that the help evaporates like a drop of rain in the Sahara sun is exhibitions of ingratitude and/or demands for special treatment.Aruis.yu wrote:Ok. Thanks for your mention and your answer, I think the guys here is very warm-heart.Alan Kirk wrote:As you've already found that kind of request won't get you a whole lot of sympathy. The forum is a group of TM1 users who are prepared to help each other out when they have time to, not a support line where someone is sitting on the other end of a Skype connection waiting for problems to be sent to them.
And it's great that you took the time to answer the question that was put to you in the previous post; that's another sure fire way to get people to spend their valuable time to help you.
I would strongly recommend that an attitude adjustment is in order if you want help from others, not just here but anywhere else on the Interwebz. This is doubly so since you appear from your e-mail address not to be an end user but from a consultancy company which claims to offer "Strong BI/DW experience and proven success in core industries". In other words, you're asking people who are in fact actual trained consultants not merely to help you but in effect to help you compete with them. In the circumstances a LOT more humility would be well advised.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: About the tm1p.xla file in version 10.1
You are right. I got it. Thanks again for your mention, and your suggestion.Alan Kirk wrote: I would strongly recommend that an attitude adjustment is in order if you want help from others, not just here but anywhere else on the Interwebz. This is doubly so since you appear from your e-mail address not to be an end user but from a consultancy company [url=http://*********/about-us/]which claims[/url] to offer "Strong BI/DW experience and proven success in core industries". In other words, you're asking people who are in fact actual trained consultants not merely to help you but in effect to help you compete with them. In the circumstances a LOT more humility would be well advised.