Search found 62 matches

by jed
Wed Sep 29, 2021 12:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web logout not working
Replies: 6
Views: 4949

Re: TM1Web logout not working

Just thought I would comment that we are on PA 2.0.9.4 and we also have this issue with the TM1Web logout button now working in Chrome.
by jed
Thu Aug 19, 2021 4:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: System crashes with user waiting on themselves
Replies: 0
Views: 65347

System crashes with user waiting on themselves

We have had 5 tm1 service crashes in the last 3 weeks. In all instances the monitoring (we use Pulse) shows a user stuck in a loop with a thread that is waiting on themselves. The threads can not be terminated (using pulse) and the user session cannot be killed. It can happen with a session in persp...
by jed
Thu Aug 20, 2020 10:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transaction Log search not working
Replies: 6
Views: 3576

Re: Transaction Log search not working

OMG @MariusWirtz this is gold :) I must learn more about TM1py..... Hi, @jed Are you using good old Architect to filter the transaction log? Architect is using the old C API which isn't going to be supported moving forward. I'm just guessing here, but perhaps it works if you filter the transactionlo...
by jed
Thu Aug 06, 2020 6:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web Websheet Snapshot to Excel taking too long
Replies: 2
Views: 1808

Re: TM1Web Websheet Snapshot to Excel taking too long

We have this issue too in PA 2.07. It appears to be intermittent though and affects static reports too with not many rows.
by jed
Wed Aug 05, 2020 5:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transaction Log search not working
Replies: 6
Views: 3576

Re: Transaction Log search not working

damn, I guess now I'll need to try and work out if it's been officially reported as a bug with IBM. I'm sure the response will be "you need to upgrade" :roll:

Handy functionality to have when users accidentally change thousands of records and you need to back them out....
by jed
Tue Aug 04, 2020 12:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transaction Log search not working
Replies: 6
Views: 3576

Transaction Log search not working

Since we upgrade to PA the transaction log search functionality does not appear to work. Sometimes it will say xxx records found then return nothing...but most of the time it can't find anything despite me being able to manually locate it in one of the transaction logs. Has anyone else encountered t...
by jed
Tue Oct 15, 2019 12:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Oracle ODBC intermitent connection failure
Replies: 3
Views: 6757

Re: Oracle ODBC intermitent connection failure

Just thought I'd post an update...after a month of connection failures whenever we loaded data from ERP we discovered that the source of the problem was that someone in IT had decided to setup network teaming on our server. Would have been good if they told us they were making a change :roll: we cou...
by jed
Mon Sep 09, 2019 1:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make system appear "offline" - TM1Web login unavailable
Replies: 14
Views: 19987

Re: How to make system appear "offline" - TM1Web login unavailable

to OFFLINE 1 savedataall 2 copy file cube }ClientsProperties to temp folder (via executecommnd) 3 change password hash for all users exclude 'admins' to ONLINE 1 cubeunload(}ClientsProperties) 2 copy file cube from temp folder to datafolder So, in this scenario if the users keeps trying to login th...
by jed
Mon Sep 09, 2019 1:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA upgrade & TM1Web reports not working
Replies: 4
Views: 4835

Re: PA upgrade & TM1Web reports not working

ok thanks...thought it might have been something fancy. Unfortunately this does not fix our problem.
by jed
Fri Sep 06, 2019 5:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Oracle ODBC intermitent connection failure
Replies: 3
Views: 6757

Oracle ODBC intermitent connection failure

We have a strange situation with Oracle (oracle 12cR2client 32bit) failing on connection. 2 identical servers (same OS, same ODBC drivers, same TM1 version (10.2.2), same TM1 data)...TI updates from ERP scheduled every 30 minutes. On one server some of the TI processes fail at every run (different p...
by jed
Wed Sep 04, 2019 3:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA upgrade & TM1Web reports not working
Replies: 4
Views: 4835

Re: PA upgrade & TM1Web reports not working

Thanks Paul, please enlighten me as to what
workbook upgrade utility
is? We are not moving to PAx or PAW just upgrading to PA 2.07.
by jed
Mon Sep 02, 2019 1:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA upgrade & TM1Web reports not working
Replies: 4
Views: 4835

PA upgrade & TM1Web reports not working

We are planning our upgrade to PA (from 10.2.2) and our biggest issue appears to be existing TM1Web reports that no longer work under PA. Any tips for things that just don't work in TM1Web under PA? In particular none of our existing charts appear to work on reports in TM1Web. Our upgrade testing is...
by jed
Sun Aug 25, 2019 11:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make system appear "offline" - TM1Web login unavailable
Replies: 14
Views: 19987

Re: How to make system appear "offline" - TM1Web login unavailable

orlando wrote: Fri Aug 23, 2019 12:19 pm
lotsaram wrote: Fri Aug 23, 2019 12:11 pm Have you looked at this?
clever way - i like ist
hopefully he's using PA
oh yeah this would be an option...unfortunately we're not upgrading to PA for a few months :roll:
by jed
Fri Aug 23, 2019 2:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make system appear "offline" - TM1Web login unavailable
Replies: 14
Views: 19987

Re: How to make system appear "offline" - TM1Web login unavailable

Nah, that's changing the homepage after the users have logged in which we do already. I need to prevent them from logging in.
macsir wrote: Fri Aug 23, 2019 2:19 am maybe this one?
https://www.ibm.com/support/knowledgece ... 509d6.html
by jed
Fri Aug 23, 2019 12:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make system appear "offline" - TM1Web login unavailable
Replies: 14
Views: 19987

How to make system appear "offline" - TM1Web login unavailable

What methods do people use for taking their system "offline" such that non admin users cannot login via TM1Web (or perspectives)? At certain times we want to take the system offline while TM1 Administrators perform certain tasks and at present even though we lock the system and advise the ...
by jed
Fri May 06, 2011 2:27 am
Forum: OLAP Jobs
Topic: TM1 Developer required in Brisbane Australia for Contract
Replies: 0
Views: 2376

TM1 Developer required in Brisbane Australia for Contract

Hi all, The company I having been contracting to for the last 2 years is looking for an experienced TM1 Developer to replace me when I leave in 2-3 months time. The company is in the Oil & Gas sector and the role is based in brisbane - I think they would be looking at a 3-6 month contract initia...
by jed
Wed Aug 04, 2010 11:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 in excel 2007 causes excel to crash on connect
Replies: 0
Views: 1522

TM1 in excel 2007 causes excel to crash on connect

We have recently upgraded to Excel 2007 and are having some issues with getting TM1 to work. For all users that previously ran perspectives in excel 2003 I delete the tm1p.ini file then start up excel 2007, add the tm1 addin and specify the admin host. On this occaision we are able to select server ...
by jed
Thu Jul 01, 2010 2:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetCreatebyMDX - remove negatively weighted elements
Replies: 1
Views: 2260

SubsetCreatebyMDX - remove negatively weighted elements

All of my cubes have drill through to cube detail setup. I use a fairly generic MDX expression to expand consolidated elements to the lowest level where DTYPE returns C (consolidated element): MDXString='{TM1FILTERBYLEVEL( {DESCENDANTS([' | MyDim | '].[' | Account | ']) }, 0)}'; This works really we...
by jed
Tue Jun 22, 2010 11:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change of Financial Year (approaches to manage)
Replies: 2
Views: 2602

Change of Financial Year (approaches to manage)

So we currently use the 2d approach for time in TM1 where year = financial year and we currently operate on a Jul to Jun Financial Year. We are being taken over by another company and their financial year is calendar year (Jan to Dec) so something will need to change in TM1. *ugh* We have all been t...
by jed
Wed Feb 24, 2010 2:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web SUBNM behaviour when security applied
Replies: 0
Views: 1428

TM1Web SUBNM behaviour when security applied

I have a strange thing happening with my TM1Web reports that use SUBNMs. I have found some similar posts about the quirks of of SUBNM in TM1Web but none that appear to highlight the exact same issue (I think..) In my TM1Web reports, each of the references to SUBNMs point to a subset that contains al...