Search found 3631 matches

by Alan Kirk
Fri Jul 19, 2019 11:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why IBM should sell off TM1 by James Wakefield
Replies: 4
Views: 1641

Re: Why IBM should sell off TM1 by James Wakefield

I wonder if he remembers - I don't (but I'm entitled not to :shock: ) I hope that's not an ageist slur upon yourself there David! After all, {mumble} is the new 20. Just look at the new Top Gun movie. A guy in his late 50's is still supposedly flying front line fighter missions as if almost 4 decad...
by Alan Kirk
Fri Jul 19, 2019 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why IBM should sell off TM1 by James Wakefield
Replies: 4
Views: 1641

Re: Why IBM should sell off TM1 by James Wakefield

Hi Gurus, I know I am opening a pandora's box out here, but being a passionate TM1 lovers, how much do you agree with James on the below: https://www.linkedin.com/pulse/why-ibm-should-sell-off-tm1-james-wakefield/ Thanks I think that it's a really interesting piece of writing. Thanks for bringing i...
by Alan Kirk
Mon Jul 15, 2019 5:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Communal activity - nominate your favourite FAQ
Replies: 0
Views: 9396

Communal activity - nominate your favourite FAQ

The once-mighty FAQ thread is in desperate need of a refurbishment. Dust, cobwebs, and references to sub-versions of version 8 can be found everywhere. At present it looks like a deceased estate. Rather than just rely on what I think should be in there, here's an opportunity for everyone to nominate...
by Alan Kirk
Mon Jul 15, 2019 4:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM Usage much larger than Cubes
Replies: 3
Views: 1068

Re: RAM Usage much larger than Cubes

Hi Mark Have you recently upgraded to PA? If so, it is probably due to MUNs. From memory the topic that I raised on this was called something like Planning Analytics using twice the memory. Do a search and you should find it. It can be found here , in fact. I've also added it to Miss Havisham's fav...
by Alan Kirk
Sun Jul 14, 2019 1:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock 4 for IBM Planning Analytics is available
Replies: 14
Views: 3389

Re: Bedrock 4 for IBM Planning Analytics is available

Personally, I don't think I'll be jumping into the Bedrock 4 pool all that soon. I have it on all of my servers, but this morning was my first encounter with using it. It was not auspicious. It was a call to }bedrock.cube.viewandsubsets.create, with pLogOutput set to 1. Yeah, all good, hunky dory, n...
by Alan Kirk
Tue Jul 09, 2019 12:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating Element Attributes in TI Process
Replies: 17
Views: 5554

Re: Updating Element Attributes in TI Process

I know I'm very late to the party on this, but today is the first time I'd had cause to use this function. It appears that if you feed an MDX expression into the third argument to update the subset: SubsetMDXSet(dimension, subsetname, [MDX_expression]); Then the function just leaves it as a dynamic ...
by Alan Kirk
Wed Jul 03, 2019 10:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Guide
Replies: 5
Views: 1228

Re: PAW Guide

Hi everyone! Does anybody have any kind of Guide or Manual for Planning Analytics Workspace? Basically to know what you can do or what can you show with it once you have the Views on Architect. I have watched the videos from the IBM YouTube channel and their Web Knowledge Center, but if you have an...
by Alan Kirk
Tue Jul 02, 2019 3:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web 2.0.6 - Bogus Timeouts
Replies: 4
Views: 1471

Re: TM1 Web 2.0.6 - Bogus Timeouts

We just upgraded our system to PA 2.0.6 over the weekend and a couple of users (well, me so far but I'm expecting more as they get to the office today) hit this one. Ops Console was fine by the way. The password change trick didn't work for me (either via Perspectives or Web). But what does seem to...
by Alan Kirk
Mon Jul 01, 2019 12:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: 10.2 Series
Replies: 49
Views: 63018

Re: Fix Pack Releases: 10.2 Series

I've just added a link to 10.2.2 FP7 Interim Fix 22.

One of the things it addresses is a security flash that IBM released last week, the details of which will be found here.

There's nothing mentioned about this affecting PA2 installations.
by Alan Kirk
Fri Jun 28, 2019 10:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Day of Week in TI
Replies: 13
Views: 5634

Re: Day of Week in TI

I'm aware that I need to update ye olde Using Dates And Times thread with that as well, but I need to update it with a number of things. Right at the moment I'm testing out issues relating to the new Excel Dates server config parameter and plan to whack the whole thing with a complete overhaul.
by Alan Kirk
Thu Jun 13, 2019 8:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI views using alternate hierarchies
Replies: 5
Views: 1169

Re: TI views using alternate hierarchies

BTW the next PA " Ask me Anything " session is TODAY. It is worth joining It's around 1am my time. I think that works better for me and better for them because the only thing I would want to "A" in an AMA is "When are you at IBM going to get your collective head out of your backside and start provi...
by Alan Kirk
Mon May 27, 2019 1:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 18
Views: 21393

Re: Fix Pack Releases: PA2 / V11 Series

A link to the 2.0.7 release has now been added. In the depreciation list, I noted:
IBM TM1 Top utility
The TM1 Top utility is scheduled for deprecation.
Again.
by Alan Kirk
Thu May 16, 2019 1:15 am
Forum: General
Topic: Microsoft has finally done something right (Excel)
Replies: 0
Views: 18579

Microsoft has finally done something right (Excel)

Rather than peeing people off by doing things like: Pulling the Recent Folders list in File Open (which admittedly they grudgingly restored after seemingly endless waves of customer protests); Introducing the work-destroying and ineptly programmed abomination that is Autosave for OneDrive*; The Ribb...
by Alan Kirk
Wed May 08, 2019 3:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 2357

Re: TI - Add new element in alphabetical order under consolidation

That said, I would not necessarily recommend using people's names as principal element names. If someone changes their name (as some newly married women have an annoying (from a system point of view) habit of doing), you'll need to export all of the data relating to that element and create a new on...
by Alan Kirk
Tue May 07, 2019 7:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 2357

Re: TI - Add new element in alphabetical order under consolidation

Sheesh this ran a little off topic. To be fair my original reply was just the first line pointing to the DimensionSortOrder function. Then I foresaw the impending pain that will inevitably come from using a description as a principal name, thought better of it, and added the suggestion that the ori...
by Alan Kirk
Tue May 07, 2019 11:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 2357

Re: TI - Add new element in alphabetical order under consolidation

Normally you would use an artificial key for this; something like an employee ID code from the HR module. You can use the name as an alias. You can then use MDX to create sorted subsets which put the elements into the order that you want. True. But start using consolidations to collapse and expand ...
by Alan Kirk
Tue May 07, 2019 8:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 2357

Re: TI - Add new element in alphabetical order under consolidation

I'm a pretty new user of TM1 (using version 10.2.4) I have a dimension that is list of employee names with a single consolidation called "All Employee Names". The dimension looks some this like this: All Employee Names adam-jones brett-smith david-collins Each time a new employee name is added to t...
by Alan Kirk
Mon May 06, 2019 10:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Views
Replies: 6
Views: 863

Re: Cube Views

This is of course ridiculously cumbersome if you have a long list of cubes and the one that has the view is right down the bottom. Lotsaram to the rescue ! https://www.tm1forum.com/viewtopic.php?f=19&t=12717&p=61981&hilit=application#p61981 Ah yes, I'd forgotten about that one. To be honest I rarel...
by Alan Kirk
Mon May 06, 2019 8:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Views
Replies: 6
Views: 863

Re: Cube Views

I was able to create a folder under applications. Now I would like to copy a view under the new folder so that it can be shared by mulitple users. The relevant documentation is here . That's 10.2.2, but the principles are the same. In short, you drag the view from under the cube and into the folder...
by Alan Kirk
Mon May 06, 2019 6:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Views
Replies: 6
Views: 863

Re: Cube Views

Is is possible to create a folder to store a cube view in? In what environment? Perspectives, the abomination that is PAW? Another interface? Please check the Request for Assistance guidelines before posting. Questions should have FULL details. If it's Perspectives you can put them in applications ...