About the tm1p.xla file in version 10.1

Post Reply
Aruis.yu
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

Post by Aruis.yu »

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.
Last edited by Aruis.yu on Thu Oct 23, 2014 11:02 am, edited 1 time in total.
declanr
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

Post by declanr »

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
Declan Rodger
Aruis.yu
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

Post by Aruis.yu »

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
declanr
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

Post by declanr »

Aruis.yu wrote: Thanks a lot. But after I read the issue, the error still exist
Which of the listed steps did you try?
Declan Rodger
Aruis.yu
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

Post by Aruis.yu »

declanr wrote:
Aruis.yu wrote: Thanks a lot. But after I read the issue, the error still exist
Which of the listed steps did you try?
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.


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.
lotsaram
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

Post by lotsaram »

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
Because this is your personal, free Cognos support line?
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.
Aruis.yu
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

Post by Aruis.yu »

Delete
Last edited by Aruis.yu on Thu Oct 23, 2014 10:57 am, edited 3 times in total.
Alan Kirk
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

Post by Alan Kirk »

Aruis.yu wrote:
declanr wrote:
Aruis.yu wrote: Thanks a lot. But after I read the issue, the error still exist
Which of the listed steps did you try?
My office is 2010,
32 bit, or 64 bit? (File => Help in Excel.)

Hint: Since you're on 10.1, if you're on Office 64 bit then don't expect the add-in to work.
Aruis.yu wrote:By the way did you have the skype for the easy communication or can you sent the email to me?
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.
"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.
Aruis.yu
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

Post by Aruis.yu »

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.
Alan Kirk
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

Post by Alan Kirk »

Aruis.yu wrote:
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.
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.

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.
Aruis.yu
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

Post by Aruis.yu »

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.
You are right. I got it. Thanks again for your mention, and your suggestion.
Post Reply