Search found 2198 matches

by jim wood
Fri Jan 11, 2019 4:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Certifications
Replies: 11
Views: 405

Re: TM1 Certifications

It's an online test Jim and therefore available to anyone worldwide. Would you, good sir, be interested in testing your mettle? For free??? :) Only kidding. If it's full of PA questions I'd be done for. The client I'm on has been stuck on version 10 for a while, heck we only upgraded to 10.2.2 as s...
by jim wood
Fri Jan 11, 2019 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Certifications
Replies: 11
Views: 405

Re: TM1 Certifications

I should mention one other relatively recent development in this field too given my great admiration and esteem for the official IBM certifications. Cubewise has partnered with Deakin University in Australia to create a credential that might, well, actually mean something. It's not free but as I un...
by jim wood
Fri Jan 11, 2019 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old TM1 version
Replies: 7
Views: 242

Re: Old TM1 version

Alan Kirk wrote:
Thu Jan 10, 2019 6:44 pm
Or built into Lotus 1-2-3. There was a time when Excel support was New! And! Exciting!
I forgot all about Lotus. I used to love Lotus. With the power keys you could do everything without touching a mouse it was awesome!!
by jim wood
Thu Jan 10, 2019 4:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old TM1 version
Replies: 7
Views: 242

Re: Old TM1 version

Architect only came with version 7. Before that it was very different. Everything was built in to Excel. Even loading data as there was no TI either.
by jim wood
Wed Jan 09, 2019 5:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Certifications
Replies: 11
Views: 405

Re: TM1 Certifications

That was my understanding as well, however there are no sales badges to replace the partner sales certifications. Also to obtain the needed level to be an IBM partner of the right level has not been updated (yet) to include the badges, hence the reason I am not ready to commit to the badges fully re...
by jim wood
Wed Jan 09, 2019 1:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Certifications
Replies: 11
Views: 405

Re: TM1 Certifications

I don't think IBM have completely sorted this out yet. For partners the requirement still is certification but as you said for TM1 there aren't any. I would just make sure you get all your badges and see where IBM go from there. Hopefully with us and other partners asking the question it'll force th...
by jim wood
Tue Dec 18, 2018 6:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to capture who edited TM1 cube?
Replies: 7
Views: 349

Re: How to capture who edited TM1 cube?

Moved to the correct forum,

Jim.
by jim wood
Fri Dec 14, 2018 5:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives - Prompt when closing Excel?
Replies: 6
Views: 229

Re: TM1 Perspectives - Prompt when closing Excel?

If I remember rightly, if you changed a view it should prompt you to see if you want to change the view? Beyond that I'm not sure if you can as it is an Excel add-in after all,

Jim.
by jim wood
Thu Dec 13, 2018 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Holds via a Ti
Replies: 7
Views: 254

Re: Holds via a Ti

Wim Gielis wrote:
Wed Dec 12, 2018 11:05 pm
I guess that Tom is confusing holds and locks.
Which is why I asked instead of being presumptuous and going straight to it.
by jim wood
Wed Dec 12, 2018 4:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Holds via a Ti
Replies: 7
Views: 254

Re: Holds via a Ti

When you say holds, do you means locks?
by jim wood
Mon Nov 19, 2018 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Work-around for granting access when there is no admin??
Replies: 5
Views: 280

Re: Work-around for granting access when there is no admin??

If you're in the "admin" group (not a group with admin access) you get admin access by default.
by jim wood
Mon Nov 05, 2018 12:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Display the current date
Replies: 3
Views: 503

Re: Display the current date

Firstly I hope you created it as an alias? Also remember they have to be unique, so if you display the current date make sure it's for either one element or it's a post fix. Lastly you need to create a rule on the control cube. Then use the Today() function. If you check the reference guide there ar...
by jim wood
Mon Nov 05, 2018 12:32 pm
Forum: General
Topic: Outsourcing options
Replies: 3
Views: 1827

Re: Outsourcing options

If it ends up offshore, one thing I would do is keep an eye on the forum. If they're having trouble with some of your requirements they'll probably end up here. So don't tell them your a member of the forum.
by jim wood
Fri Nov 02, 2018 2:44 pm
Forum: Useful code, tips and tricks
Topic: Deactivating chores in Architect takes time
Replies: 9
Views: 1006

Re: Deactivating chores in Architect takes time

Excellent, thanks David. Btw shouldn't that be a broken record? :D
by jim wood
Thu Nov 01, 2018 7:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Case Sensitive vs. TM1 10.2 not case sensitive
Replies: 6
Views: 445

Re: PA Case Sensitive vs. TM1 10.2 not case sensitive

lotsaram wrote:
Thu Nov 01, 2018 5:50 pm
If (more likely when) case sensitivity is introduced I think it is a very safe bet that this will be controlled by a tm1s.cfg parameter where the default value is set to false for backwards compatibility.
We all know how well these things have worked in the past......
by jim wood
Thu Nov 01, 2018 4:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Case Sensitive vs. TM1 10.2 not case sensitive
Replies: 6
Views: 445

Re: PA Case Sensitive vs. TM1 10.2 not case sensitive

tomok wrote:
Thu Nov 01, 2018 4:23 pm
I think they mean PA is case sensitive for TM1 objects like cubes, dimensions, elements, attributes, etc. Not variable names inside a TI process.
Oh yah, copy and paste ahoy!!
by jim wood
Mon Oct 22, 2018 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Invalid picklist detected for cube
Replies: 5
Views: 358

Re: Invalid picklist detected for cube

Moved to correct forum.
by jim wood
Thu Oct 11, 2018 1:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders: rule based on constant values
Replies: 3
Views: 300

Re: Feeders: rule based on constant values

Normally you've got 3 options with this: 1) Don't feed it 2) Feed with with an element constant (an example that's not related may be price) 3) Variable feed from the constant, which may be an issue if your variable is constantly changing You may want to also look at making the element a consolidati...
by jim wood
Wed Oct 10, 2018 5:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: attributes in data tab
Replies: 4
Views: 385

Re: attributes in data tab

Something to consider is commitment... Now then fellas don't all run away!!! I mean when TM1 commits changes. Unless you're using the add direct formula the elements aren't committed to the dimension until once the meta tab has been completed. As others have others have stated attributes are simply ...
by jim wood
Wed Oct 03, 2018 12:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Service Strange Behaviour
Replies: 5
Views: 325

Re: Service Strange Behaviour

Finally found out. It was nothing to do with whether or not the processes were loaded in to memory. They were. The issue was to do with CAM and security. We think the groups dimension had become corrupted. When logging in we were not assigned to any group so we could not see anything or save anythin...