Search found 258 matches

by John Hammond
Fri Feb 09, 2018 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Feeder
Replies: 6
Views: 945

Re: String Feeder

Never put any feeder info into Security Cubes as they get evaluated top down anyway. So macsir's suggestion would work. How you feed a constant has always been a bit of a gripe for me, since constants are not derived, and I believe there should be syntax in TM1 feeders along the lines of FeedByDefau...
by John Hammond
Wed Feb 07, 2018 6:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx for MSExcel (formerly CAFE) errors explained
Replies: 3
Views: 498

Re: PAx for MSExcel (formerly CAFE) errors explained

Renaming Pax from Cafe

Exploration View = Café Crosstab
Quick Report = Café FlexView
by John Hammond
Wed Feb 07, 2018 5:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx for MSExcel (formerly CAFE) errors explained
Replies: 3
Views: 498

PAx for MSExcel (formerly CAFE) errors explained

COI-ERR-2016 Worksheet protected IBM Cognos Styles cannot be populated

The current worksheet in the workbook just opened is protected.

WA: Save the workbook with a different worksheet or use a cover sheet. This message is informational but may put a user off.
by John Hammond
Tue Feb 06, 2018 3:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tools to copy and rename TM1 object
Replies: 6
Views: 689

Re: Tools to copy and rename TM1 object

Text Substitution works fine on TM1 objects provided the original and replacement texts are the same length. Don't attempt otherwise or you will just bust your instance and even with the above proviso always have a backup of your original instance.
by John Hammond
Tue Feb 06, 2018 2:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel: Element of Subset?
Replies: 8
Views: 1131

Re: Excel: Element of Subset?

IIRC

ELISANC(dimname, subname, elementname)

works in Excel but nowhere else as does ELISPAR.

Otherwise use SUBNM with index 1,2 to iterate the subset on a hidden page and do VLOOKUP.
by John Hammond
Mon Feb 05, 2018 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Chore resubmitting itself when Locked out by another Process
Replies: 4
Views: 602

Re: Chore resubmitting itself when Locked out by another Process

Hi Alan Thanks for the update. Yes, it has been a long time - think you had the Mr T icon back then! :D I've updated my profile as requested. Absence down to overzealous internet filters. Many times I tried to point out that this was an aid to TM1'ers only to be met with a sea of indifference and be...
by John Hammond
Mon Feb 05, 2018 9:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Chore resubmitting itself when Locked out by another Process
Replies: 4
Views: 602

Chore resubmitting itself when Locked out by another Process

Folks I have an unusual situation in that I have a chore that runs hourly. The chore runs a single process and the setting is such that it treats the chore as a single transaction. The single process has about 8 sub processes and takes about 2 mins to run. There is no start batch updates / end batch...
by John Hammond
Fri Dec 15, 2017 10:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change in Element Name of a frequently used Dimension
Replies: 14
Views: 1466

Re: Change in Element Name of a frequently used Dimension

Can confirm what the guys are saying on here. I have a Dirty Cube Process somewhere which I can upload. Forewarning for users of PM - you don't see the SwapAlias results unlike in good ol' Perspectives. One thing where I think IBM missed a trick was the Caption which could have been used as the unal...
by John Hammond
Thu Nov 23, 2017 10:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: App-V install of TM1 Cafe requires multiple reboot of machine to start
Replies: 0
Views: 522

App-V install of TM1 Cafe requires multiple reboot of machine to start

Just wondered if anyone had seen this problem before We have the Café add in installed under APP-V (Microsoft Virtualisation software that allows an application to run without conflicts as if it is the only application on the machine). The Café add-in works fine and then suddenly we are in a situati...
by John Hammond
Thu Jan 05, 2017 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 array of subset error
Replies: 16
Views: 4706

Re: TM1 array of subset error

The problem is when view or subset refers to aliased element in list and the alias gets removed.

Still in latest 10.2.2 prod version of TM1
by John Hammond
Sat Nov 07, 2015 7:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to prevent a commit / force a rollback
Replies: 16
Views: 3610

Re: How to prevent a commit / force a rollback

Wouldn't having a top process with called process steps in the prolog with conditional process quits between the steps. Commit only occurs at the end of the top processes' epilog
by John Hammond
Tue Mar 26, 2013 8:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Input view immune from changes made in TI?
Replies: 2
Views: 640

Re: Input view immune from changes made in TI?

Thanks David. That answer fits with my experience.
by John Hammond
Mon Mar 25, 2013 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Input view immune from changes made in TI?
Replies: 2
Views: 640

Input view immune from changes made in TI?

Does Tm1 construct the entire view prior to loading it to a TI or does it construct it from the cube bit by bit.? In the second case you would expect changes made in the TI to show in the data in the view and you would lose keys that you had zeroed out. Did some tests which suggest that case 1 pre-b...
by John Hammond
Wed Nov 14, 2012 5:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM PVUs based on VM processors or Physical Processors
Replies: 3
Views: 1130

Re: IBM PVUs based on VM processors or Physical Processors

Cheers Mate Following these links On April 7, 2009, IBM announced that most PVU*-based software products are eligible for Sub-capacity Licensing. Exceptions to that eligibility are listed below. * Please refer to the announcement letter for additional details at: http://www-01.ibm.com/common/ssi/ind...
by John Hammond
Wed Nov 14, 2012 10:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM PVUs based on VM processors or Physical Processors
Replies: 3
Views: 1130

IBM PVUs based on VM processors or Physical Processors

Hi another question on the unweeded garden that is TM1 licencing. Is there any truth in rumour IBM ignores processor limit assigned to VMs when calculating PVUs and goes for the physical machine on which the VM resides. Ie have max of 4 cores dedicated to our VM which equates to 4 * 70 = 280 PVUs, b...
by John Hammond
Mon Oct 08, 2012 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Locking down cube area from change incl TI procs/admins
Replies: 10
Views: 3367

Re: Locking down cube area from change incl TI procs/admins

matt

The problem is that admin access is implicit when you run a TI. In addition dimension locking does stop admins.

Mvaspal

That sounds an interesting work-around. Can you reserve by rules or using TI processes rather than just manually?

Thanks to all responses.
by John Hammond
Mon Oct 08, 2012 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Locking down cube area from change incl TI procs/admins
Replies: 10
Views: 3367

Re: Locking down cube area from change incl TI procs/admins

sorry should have elucidated further. You have to use a cellsecurity cube to do multi-dimensional security. However putting LOCK in the cellsecurity cube does not Lock that group but grants that group 'LOCK' privelege to that cell. Honestly I thought the exact same as you Tomok but if you try it you...
by John Hammond
Mon Oct 08, 2012 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Locking down cube area from change incl TI procs/admins
Replies: 10
Views: 3367

Locking down cube area from change incl TI procs/admins

If the cube area is defined by a single dimension then you would place a lock on the dimension element. If the cube area is defined by multiple dimensions then you would have to use a security cube. However the highest level of protection that you can put on the area is 'READ'. (NB 'ADMIN' gives adm...
by John Hammond
Thu Oct 04, 2012 3:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube size - is this a record?
Replies: 8
Views: 1419

Re: Cube size - is this a record?

Worried about getting your Model out at the TM1 conference? Then try FEEDERMAX (R) Pills and your RAM is guaranteed to measure up! Only $99.99 for a pack of 20. Order 200 or more and receive a 600Watt cooling fan for your tower. Just listen to the testimonials: Mr W - Brisbane Australia We had the o...