Search found 41 matches

by JDLove
Thu Jul 20, 2017 9:12 am
Forum: OLAP Jobs
Topic: WANTED: Contract TM1 work
Replies: 0
Views: 1068

WANTED: Contract TM1 work

Hi I'm looking for extra work within the TM1 space, ideally contract based, able to be flexible based on term. CV provided on request, heaps of solid experience and currently based in NZ. Have dual nationality so able to work in UK/EU and depending on term could look at travel. Ideally a shorter ter...
by JDLove
Tue May 16, 2017 10:10 pm
Forum: OLAP Jobs
Topic: TM1 Developer - £550 per day - 6 months - Canary Wharf - Global Bank
Replies: 8
Views: 2501

Re: TM1 Developer - £550 per day - 6 months - Canary Wharf - Global Bank

:-( 550 GBP pday was a common/avg rate in 2006/7 10 years ago ( in London ).
by JDLove
Mon Apr 24, 2017 1:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sublime Text TM1 syntax highlighter
Replies: 6
Views: 1844

Re: Sublime Text TM1 syntax highlighter

Thanks Paul that was what I missed !
Did you install RegReplace? This is required for the convert bit to work.
Not the easiest to install, but I suspect mostly it was me not following instructions carefully :?
by JDLove
Mon Apr 24, 2017 10:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sublime Text TM1 syntax highlighter
Replies: 6
Views: 1844

Re: Sublime Text TM1 syntax highlighter

Thanks Paul, This will be in your user directory settings, so for me this is c:\users\psegal\appdata\roaming\sublime text 3\packages\user. Obviously you need to change as appropriate for your username etc. Now having copied the 3 files to the directory and restarted "Sublime Text 3". I dont see the ...
by JDLove
Mon Apr 24, 2017 6:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sublime Text TM1 syntax highlighter
Replies: 6
Views: 1844

Re: Sublime Text TM1 syntax highlighter

Hi I'm interested to try like the look. I've - downloaded and installed Subline Text 3 - added the package control to Sublime Text 3 Where is that folder structure required to copied the TM1 folder and other files in ? Step 2."Copy GitHub folder TM1 to ..\Sublime Text\Data\Packages\User\TM1" Step 4....
by JDLove
Fri Oct 09, 2015 4:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidated Financial Statements in TM1 ?
Replies: 13
Views: 6204

Re: Consolidated Financial Statements in TM1 ?

JD, If you're still out there, can you provide an update on this potential implementation of financial consolidation in TM1? Were you successful? I'm curious because I am very interested in doing the same thing but our financial reporting team is wary of being pioneers (for good reason it seems - I...
by JDLove
Tue Sep 22, 2015 12:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Blueprints
Replies: 5
Views: 1052

Re: TM1 Blueprints

lotsaram wrote:Why would you want them? They were pretty cr@ppy.

That would be putting it nicely as far as what I have seen for either EP or TM1...

If your looking for techniques for Capex and Depn send me a PM I can send you what I do.

Regards
James
by JDLove
Wed May 20, 2015 2:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Modeling HFM in TM1
Replies: 3
Views: 1653

Re: Modeling HFM in TM1

Here's book I was given as part of my project (years ago now), I found it very practical.

Ng Eng Juan, Consolidated Financial Statements (Singapore), McGraw-Hill
by JDLove
Tue May 19, 2015 6:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Modeling HFM in TM1
Replies: 3
Views: 1653

Re: Modeling HFM in TM1

Hi, Fine and ambitious project ! I have spent some months designing and building a TM1 model, working through the process and attempting to refine a generic result. I've not completed it or polished it up, its raw cubes and rules/TI, however, its had some time and thought applied and I would be open...
by JDLove
Sat Aug 30, 2014 3:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Applications or Excel & VBA what say you ?
Replies: 1
Views: 820

TM1 Applications or Excel & VBA what say you ?

TM1 Applications have been around for awhile now and I first started using them in 2010 when they were called Contributor applications and it was dam buggy. At the time we started with Excel but the users clearly pushed for a web based UI and had been sold this in pre sales so we took it on, it was ...
by JDLove
Thu Jan 16, 2014 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Putting Expand function to a good use
Replies: 11
Views: 4402

Re: Putting Expand function to a good use

I think I got it working ... I'll test it then post up the TI script for others if they need it
JD
by JDLove
Thu Jan 16, 2014 9:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Putting Expand function to a good use
Replies: 11
Views: 4402

Re: Putting Expand function to a good use

Hi I am thinking about loading from a CSV file that's just like this but its got Year_Month for 6 years so 72 columns. Is it possible to loop thought and build a string variable then assign this as the Value in the CELLPUTN(Value,'CubeName,Dim1....) My Import Columns are nicely named Y01_M01,Y01_M02...
by JDLove
Fri Jan 03, 2014 5:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding date in TM1 webapp adds one year
Replies: 5
Views: 1156

Re: Adding date in TM1 webapp adds one year

While developing a simple date driven application we found this last week.
It looks like a bug and I was informed a PMR was raised with IBM.
by JDLove
Thu Sep 05, 2013 9:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Spreading Hold not visable in Excel 2010 with CX
Replies: 3
Views: 1038

Re: Spreading Hold not visable in Excel 2010 with CX

Heard back from the client/ IBM partner

" The issue with the hold cells indicator not being shown in Perspectives
is a known issue and logged under APAR PM7026
It will be fixed in the next release of CX 10.2 "
by JDLove
Mon Sep 02, 2013 8:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Spreading Hold not visable in Excel 2010 with CX
Replies: 3
Views: 1038

Re: Spreading Hold not visable in Excel 2010 with CX

Hi Lotsaram

Yes seems we both posted, I had mentioned I was going to post this but was away traveling last week.
I'll try and get it taken up with IBM and report back once its resolved.

thanks
JD
by JDLove
Sun Sep 01, 2013 9:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Spreading Hold not visable in Excel 2010 with CX
Replies: 3
Views: 1038

Spreading Hold not visable in Excel 2010 with CX

Hi

CX 10.1
Excel 2010

We have developed some nice excel forms for spreading volumes but the small red triangle that indicates a cell is "held" is not showing.
Has anyone else found this an issue with a similar setup ?

Regards
JD
by JDLove
Wed Jul 24, 2013 7:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Version / Scenario dimension best practice
Replies: 11
Views: 2823

Re: Version / Scenario dimension best practice

Hi, I am not sure I fully grasp all the issues here... I would think though that one data load is enough then use rules to reference. If you want the Regulators as a dimension, then you could add a dummy element to load into, then rules reference this for the calculations. ['Risk Exposure'] = N: IF(...
by JDLove
Wed Jul 24, 2013 6:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Actual and Forecasting
Replies: 3
Views: 1098

Re: Actual and Forecasting

Hi hpansar, If I read what you have written correctly... I would write a STET rule for the actual version first. ['Actual','Value']=N: IF ( ATTRN( 'MonthYearFiscal', !MonthYearFiscal, 'End Date Value' ) < ATTRN( 'MonthYearFiscal', DB('Control', 'Current Actual Month' , 'String' ), 'End Date Value' )...
by JDLove
Thu Jul 11, 2013 5:37 am
Forum: Commercial and Events
Topic: iPhone/Android Testers Needed - Spark Mobile
Replies: 2
Views: 3239

Re: iPhone/Android Testers Needed - Spark Mobile

Hi Kyro,

Sure let me see if I can get his setup, I use Android !

Regards
JD
by JDLove
Thu Jul 11, 2013 4:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidated Financial Statements in TM1 ?
Replies: 13
Views: 6204

Re: Consolidated Financial Statements in TM1 ?

Hi Mike & Steve, Its was only the other day I was speaking to some sales guys in a meeting and they again asked me if TM1 could be used for Financial Consolidation, of which I replied yes but it depends on the complexity as to whether its the best option. They responded that at the past company they...