Search found 32 matches

by Neil Watson
Thu Nov 24, 2016 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Instance Stops unexpectedly
Replies: 8
Views: 2631

Re: TM1 Server Instance Stops unexpectedly

Hi Mark, The unrepeatable crashes are the most infuriating. Assuming the models are ok, and it appears they are, then any error hints towards a possible hardware issue and a corrupt file / memory block. Can you get IT to run deep diagnostics over both the disk and the RAM? If any of the files are in...
by Neil Watson
Tue Nov 22, 2016 11:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Instance Stops unexpectedly
Replies: 8
Views: 2631

Re: TM1 Server Instance Stops unexpectedly

Are you running out of disk space?

Has the server recently had a "Security update?"
by Neil Watson
Mon Nov 21, 2016 4:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: The SSL break and TM1Top
Replies: 6
Views: 2365

Re: The SSL break and TM1Top

I did this at the weekend, Change the path to where your new certificates are; we've moved to V2 certificates and had to add this line to the tm1top.ini file AdminSvrSSLCertAuthority=\\ServerName\TM1SSL\SSLCertificates\tm1ca_v2.pem If the certificates are in a "new" folder then you'll have to point ...
by Neil Watson
Wed Oct 01, 2014 3:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "Session timed out"
Replies: 4
Views: 2113

Re: "Session timed out"

dharav,

have you tried chaning this variable in tm1s.cfg (you'll need to restart the tm1 service after changing this)

IdleConnectionTimeOutSeconds=7200



Good Luck
Neil
by Neil Watson
Fri Sep 26, 2014 1:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IF I AM NOT attrs
Replies: 7
Views: 2980

Re: IF I AM NOT attrs

Hi, there are a number of ways to approach this, but first we need to identify exactly what you mean by Grey it out. I'm going suggest that you want to allow input when the Month = This Month and not when it isn't. Possible 1 Create another cube which will hold the Ratings data and is fully open to ...
by Neil Watson
Wed Nov 27, 2013 10:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Query
Replies: 7
Views: 2356

Re: MDX Query

Getting the Filter mdx function to work, and this may well be not the only way but

{filter({tm1subsetall([Customer])}, [Customer].CurrentMember.Name = "123456789")}

the fun part is that the "123456789" can also be a reference to another cube if you're exploring mdx

Cheers
Neil
by Neil Watson
Wed Nov 27, 2013 9:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Query
Replies: 7
Views: 2356

Re: MDX Query

Hi, There is an mdx expression window and expression recorder in the subset editor that you can turn on to help in developing your query however, I believe the syntax could be {TM1FILTERBYPATTERN({TM1FILTERBYLEVEL( { TM1SubsetAll([Customer] ) } ,0 ) } ,"20001744" ) } so replacing the FILTER function...
by Neil Watson
Thu Oct 31, 2013 11:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create rule for Projection
Replies: 10
Views: 2985

Re: Create rule for Projection

Hi Chris, 2 quick things 1. if you want the rule to apply only to N level (the lowest level) elements then you need to include N: in your rule statement ['Revenue PROJ']= N: if(ATTRN('Time', !Time, 'IsClosed') = 0, ['Revenue'], ['last 6 months','Revenue']/6); equally you can add a C: which will mean...
by Neil Watson
Tue Feb 05, 2013 12:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Do selections of dimensions in excel and run export process
Replies: 1
Views: 546

Re: Do selections of dimensions in excel and run export proc

Hi Peter, If the need is for a user to push data into a sql table via the web then yes I believe this is possible. The web form will need to have all of the parameters easily definable. e.g. For Periods Column A P1, P2, P3 etc, Column B Export or blank (you can still use data validation on the web) ...
by Neil Watson
Wed Jan 30, 2013 5:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Staff Cube with Movement Analysis - Feeders & Consolidations
Replies: 2
Views: 855

Re: Staff Cube with Movement Analysis - Feeders & Consolidat

Hi RJ, I'm not sure if I understand the issue properly but here's a guess. You want FTE's to roll up in Overtime but Directs to have an OverTime value of 0. If this is what you want then, the easiest way looks to be, either to 1. Check the alias of the Account Code Name using subst to see if the 1st...
by Neil Watson
Wed May 25, 2011 4:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use Active Form but found duplicate Hierachy
Replies: 9
Views: 3490

Re: Use Active Form but found duplicate Hierachy

Hi there, When you save you saved, did you first use the Active form option from the ribbon of "Rebuild Current Book", this will rebuild and redefine the ranges and formula for the Active form. Secondly, there is a hidden sheet called "AR01" which holds the row information, if the hierarchy had beco...
by Neil Watson
Fri Nov 26, 2010 12:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Crash
Replies: 18
Views: 5782

Re: Excel Crash

Hey there,

Following on from Steve's reply, you have at least 3 other add-ins loaded at the same time as TM1.
Livelink, TNT, Adobe PDF, it is quite probable that one of these is causing a conflict.
As suggested cn you disable them (unload) one at a time and see if this helps.




Cheers
Neil
by Neil Watson
Wed Nov 24, 2010 1:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web Login Error
Replies: 11
Views: 3084

Re: TM1Web Login Error

Hi there, Are you using integrated login and CAMIDs? If so have you added the user to the correct group via the Controller environment, as CAMID security will override any groups in tm1, ie. if you're in group demo in tm1 but not in group demo via the CAM group then the tm1 login will not see it as ...
by Neil Watson
Thu Nov 11, 2010 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1top with CAM security
Replies: 8
Views: 2426

Re: tm1top with CAM security

Hi Dan, Unfortunately this is a known bug and there is nothing that I know you can do about it. (I hope someone knows differenty), however, during the recent presentations by IBM when talking about 9.5.2 it was mentioned that this bug will be fixed, along with a change so that you will be able to se...
by Neil Watson
Wed Nov 10, 2010 1:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change sort of columnns in TM1Web
Replies: 2
Views: 996

Re: Change sort of columnns in TM1Web

Hi Toto, When a websheet is uploaded to the web there is no idea of selecting a column and doing a dynamic sort, however, there are a number of different ways to achieve this, 1. Static Subsets - create a subset in the order required, asc or desc or any order at all; and then reference this via form...
by Neil Watson
Wed Oct 06, 2010 10:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Alignment of Values in Tm1Web
Replies: 3
Views: 1184

Re: Alignment of Values in Tm1Web

Hi, The alignment used by Web is determined by the alignment set in Excel (either from the Home Ribbon or formatting toolbar or cell Properties), it is possible to align both text and numeric value left, right or centre and also top bottom too. However, there is a known issue with column widths and ...
by Neil Watson
Wed Oct 06, 2010 10:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issues migrating data to another cube
Replies: 3
Views: 906

Re: Issues migrating data to another cube

Hi there, The easiest way to test if your view is creating correctly is to expand the cube list in Server Explorer / Arcitect, expand Views, Right Click and export as ascii output / text data. this should bring up your view in the dialgoue box, and show what the current selections are, including whi...
by Neil Watson
Tue Oct 05, 2010 3:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with security rights and public on BI (+)
Replies: 1
Views: 763

Re: Problem with security rights and public on BI (+)

Hello there, There are a number of things to check, 1. Have you set the TM1 cube properties - you need to specify a measures and a time diemsnion for some parts of BI (tm1->cubename->Right Click->Properties 2. Have you set the }HierarchyProperties cube - you need to give the the levels in a tm1 dime...
by Neil Watson
Tue Sep 28, 2010 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web - can't open report
Replies: 4
Views: 3266

Re: TM1 Web - can't open report

Hey there Martin, The issue probably lies with Excel 2010. Although the xls is in an old version won't the rendering still be done using Excel 2010. As yet this version, even in 9.5, is unsupported. I suspect the whole point of this was to establish if it worked though! If you install Excel 2003 or ...
by Neil Watson
Mon Aug 16, 2010 12:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules and defining Areas partially twice
Replies: 13
Views: 2700

Re: Rules and defining Areas partially twice

HI there,

Is there a ru$ file in the data directory, as this has an impact of rules you save, appear to be saving properly but don't actually change?

More thoughts as they come to me - it may take a while

Cheers
Neil