Search found 2231 matches

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: 172

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: 297

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: 297

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: 343

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: 343

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: 343

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: 1267

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: 268

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: 1110

Re: Cognos Analytics 11.0.13

He must be a wizard to get it working on a mac!!
by jim wood
Mon May 06, 2019 12:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics 11.0.13
Replies: 12
Views: 1110

Re: Cognos Analytics 11.0.13

Here in this forum, I am expecting the answers not the comments/advice. You may be a bit out of luck there my friend. This is a volunteer community, that's here to help, but also to offer opinions. As with any development there can be more than one way to skin the cat. Opinions can be helpful as yo...
by jim wood
Fri May 03, 2019 4:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics 11.0.13
Replies: 12
Views: 1110

Re: Cognos Analytics 11.0.13

Really? You don't even bother to search the IBM web site? You just automatically post on here hoping someone else will do it for you? To be fair the IBM install instructions can be patchy at best. Not all I might add, but some for sure. Which is why some people create their own. So asking isn't a c...
by jim wood
Tue Apr 16, 2019 11:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express Trial - Can someone provide me the installation?
Replies: 9
Views: 898

Re: Cognos Express Trial - Can someone provide me the installation?

Alan,

I was able to get to here: https://www.ibm.com/account/reg/us-en/s ... =urx-33269 from within the US so Peg you may be good. See this is why we don't lock threads!!

Happy days!!

Jim.
by jim wood
Mon Apr 15, 2019 11:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express Trial - Can someone provide me the installation?
Replies: 9
Views: 898

Re: Cognos Express Trial - Can someone provide me the installation?

We don't tend to close threads. As time changes so (sometimes) do the things discussed. You never know in a few months IBM may start offering a trial. Then you'll be good to go. One thing I would mention is IBM lease cloud versions of PA. I don't the price of such things but it might worth looking i...
by jim wood
Fri Apr 12, 2019 11:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: calculating WTD, YTD and QTD with rules
Replies: 5
Views: 910

Re: calculating WTD, YTD and QTD with rules

Moved to the correct forum.
by jim wood
Fri Apr 05, 2019 6:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express Trial - Can someone provide me the installation?
Replies: 9
Views: 898

Re: Cognos Express Trial - Can someone provide me the installation?

If you're doing this as genuine evaluation to purchase the software, I'm sure some kind of temporary access can be granted to the cloud based software. You'd need to contact IBM and work on it with a sales executive. Keep in mind they won't do anything like this unless they feel this is genuine oppo...
by jim wood
Tue Mar 26, 2019 4:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: active form stacked dimension filter by level
Replies: 2
Views: 216

Re: active form stacked dimension filter by level

Have you tried using MDX for the second column? You would need something to link off so there would need to be a relationship between the 2 for the MDX to work off, rather than saying just display this...
by jim wood
Tue Mar 12, 2019 11:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO connection from 10.2.2 instance to PA instance
Replies: 1
Views: 558

Re: ODBO connection from 10.2.2 instance to PA instance

I'm not sure of the ins and outs of this (not sure if it's even possible) but my first inclination would be to overlay the ODBO drivers on the 10.2.2 machine with the ones from the PA machine, taking a backup first of course. I can only guess that the 10.2.2 drivers are not able resolve the connecti...
by jim wood
Mon Mar 11, 2019 11:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Forecasting & Budgeting
Replies: 3
Views: 800

Re: Forecasting & Budgeting

Moved to the correct forum. I'll get my tin hat ready for when Tomok sees this!!