Search found 2247 matches

by jim wood
Fri Oct 11, 2019 10:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "Lock" Actual Data in a forecast application
Replies: 6
Views: 749

Re: "Lock" Actual Data in a forecast application

The way I've done it in the past and do at the current client is to have actual and forecast as seperate versions. Have an actual flag on the time dimension, then pull via rules actual data in to forecast when the flag is set. This way you lock the actual periods via rules (no security needed) and y...
by jim wood
Mon Oct 07, 2019 12:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different rules for same element in different hierarchies
Replies: 6
Views: 390

Re: Different rules for same element in different hierarchies

Wim Gielis wrote:
Fri Oct 04, 2019 9:26 pm
Steve Rowe wrote:
Fri Oct 04, 2019 3:26 pm
:lol: My golden rule, never answer a forum post before two cups of coffee!
Well, goodbye then.
I hate coffee and will never drink it.
Even if it means leaving the forum :lol:
I can't stand it either. That may be the reason why my answers make no sense?
by jim wood
Fri Oct 04, 2019 1:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different rules for same element in different hierarchies
Replies: 6
Views: 390

Re: Different rules for same element in different hierarchies

I don't think what you want to do is possible, the N level of a cube is common for all hierarchies. C levels are different, same named C level members in different hierarchies are distinct members. The moral of that story is don't try and answer questions at 6.30 in the morning. :oops: You are of c...
by jim wood
Fri Oct 04, 2019 10:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different rules for same element in different hierarchies
Replies: 6
Views: 390

Re: Different rules for same element in different hierarchies

C level rule, if statements and elisanc. That's the way I'd go about it.
by jim wood
Mon Sep 23, 2019 10:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrade to Planning Analytics from TM1 10.1.1 Version
Replies: 3
Views: 229

Re: Upgrade to Planning Analytics from TM1 10.1.1 Version

No we haven't increased RAM and also we haven't installed installed PAW or any of its resource sapping stuff. We have server & web installed on the same test box for now, so that may explain the performance up tick,

Jim.
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: 3
Views: 229

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

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

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

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

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

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

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

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

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

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

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

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

Re: ODBO Process

Daft question but do you have a default subset set for the dimension? Does it include the alias?