Search found 2242 matches

by jim wood
Thu Sep 19, 2019 4:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrade to Planning Analytics from TM1 10.1.1 Version
Replies: 2
Views: 124

Re: Upgrade to Planning Analytics from TM1 10.1.1 Version

I've just done an upgrade from 10.2.2 to PA 2.0.7 and had no issues. W were on 10.1.1 for a long time and the upgrade to 10.2.2 raised no issues. Keeping in mind not that much has changed on the server side you should be good. I would say that we've noticed huge increase in web sheet performance in ...
by jim wood
Thu Sep 19, 2019 12:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.7 TM1 Web and BI 10.2.2
Replies: 2
Views: 169

Re: PA 2.0.7 TM1 Web and BI 10.2.2

Interestingly I've managed to get it kind of working. Gtonkin I went through the link and added the pmhub file which was missing and set the parameters. It now does work as long as I don't use localhost on the machine itself. Also now when logging out I get the following error: PA Web Firewall Error...
by jim wood
Wed Sep 18, 2019 5:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.7 TM1 Web and BI 10.2.2
Replies: 2
Views: 169

PA 2.0.7 TM1 Web and BI 10.2.2

Guys, I know IBM say that this combo isn't supported but I've got to get it working before the end of Sept with the support for TM1 10.2.2 ending. So far I have been able to install TM1 server and clients. I've been able to connect to the current CAM server and I'm able to login through good old per...
by jim wood
Tue Sep 03, 2019 3:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to access newly created tm1 server instance
Replies: 8
Views: 498

Re: How to access newly created tm1 server instance

How have you configured the security? Which mode 1-5? Are you using CAM? You need to give us much more details,

Jim.
by jim wood
Tue Sep 03, 2019 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA as Data source for BI
Replies: 0
Views: 117

PA as Data source for BI

Guys, According to this release from IBM: http://www-01.ibm.com/support/docview.wss?uid=swg21999196 PA is not supported as a data source for BI 10.2.x. Has anybody tried using PA as data source for Bi version 10.2? With support for TM1 10.2.2 coming to an end we're being forced (pretty much) to upgr...
by jim wood
Fri Aug 09, 2019 11:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 2314

Re: automation import users from active directory

Thank you guys all! Especially Paul SImon, you were right that CAMID is a derivative of the client’s property. And how it is all arranged, I will now tell for inquiring minds and for people whose life has faced this situation. So, we begin: The structure of CAMid is as follows: CAM (<NAMESPACEID>: ...
by jim wood
Thu Aug 08, 2019 6:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: websheet function equivalent to cellisupdatable
Replies: 2
Views: 434

Re: websheet function equivalent to cellisupdatable

If it's done by rule then your stuffed, unless it is controlled by some kind of flag. If it's security based you can always pull in the control cube values and format the cells based on those values and then hides those rows / sheets,

Jim.
by jim wood
Wed Aug 07, 2019 1:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 2314

Re: automation import users from active directory

macsir, paulsimon there is one important detail, we avoid associating users with AD or BI groups; therefore, we use Integration Mode 5 so that we have the opportunity to bind CAm users to groups created in TM1! You have already spent more time posting on this board than it would have taken you to m...
by jim wood
Mon Jul 29, 2019 10:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: No ODBC preview
Replies: 2
Views: 450

Re: No ODBC preview

Are you using the same user in the ODBC as you are when running the query yourself? Sounds like security rights for the ODBC user to me.
by jim wood
Wed Jul 10, 2019 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM License Metric Tool?
Replies: 5
Views: 360

Re: IBM License Metric Tool?

Mac, I've literally just done it. The best thing for me was the series of videos on you tube. It's on the IBM channel. Find the play list and follow them. Some bits have moved away from the videos but what you need to do instead is covered in the video comments, Jim. PS. I would include the link but...
by jim wood
Mon Jul 01, 2019 3:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 service holding open ODBC?
Replies: 7
Views: 478

Re: TM1 service holding open ODBC?

Sorry I meant the epilogue. In my defense it was first thing in the morning and there wasn't even a sniff of caffeine yet!! So yes close the ODBC in the epilogue. :oops:
by jim wood
Mon Jul 01, 2019 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 service holding open ODBC?
Replies: 7
Views: 478

Re: TM1 service holding open ODBC?

In the same process do you have ODBCClose in the prologue?

Jim.
by jim wood
Mon Jul 01, 2019 11:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO Process
Replies: 11
Views: 730

Re: ODBO Process

Daft question but do you have a default subset set for the dimension? Does it include the alias?
by jim wood
Thu Jun 27, 2019 3:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO Process
Replies: 11
Views: 730

Re: ODBO Process

Oh and btw, Tomok was right. If you've selected a cube as the source then it will be using a view as the source. Based on what I can tell from your screen shots this is the case. I can't see the full generated MDX query. It might help if you post that here.
by jim wood
Thu Jun 27, 2019 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO Process
Replies: 11
Views: 730

Re: ODBO Process

Jorge, I've only done a bit with ODBO but in my experience the GUI is flakey at best. Once I generated the required MDX I straight away set the input to no action, set the dimensions to data load only and set the override data source in the prologue. Also make sure you stop the generated code from w...
by jim wood
Tue Jun 11, 2019 1:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspective Vs Pax
Replies: 10
Views: 1598

Re: TM1 Perspective Vs Pax

Does anyone know if IBM planning to ditch/not support perspectives in the near future? I've heard many different rumors / pointers on this one. I would say however I believe that their long term goal is to get rid of perspectives. They tried with Performance Modeler but we all know how well that we...
by jim wood
Tue May 14, 2019 8:23 pm
Forum: General
Topic: Another Intel Backdoor CPU Problem
Replies: 0
Views: 1145

Another Intel Backdoor CPU Problem

Guys,

According to Intel, they've found another back door is any processor made before 8th and 9th Gen. They recommend disabling hyper-threading. That'll help MTQ!!! Not!!

https://www.tomshardware.com/news/intel ... 39333.html
by jim wood
Tue May 07, 2019 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics 11.0.13
Replies: 12
Views: 1414

Re: Cognos Analytics 11.0.13

He must be a wizard to get it working on a mac!!