TM1 Forum

JDLove

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...

JDLove

550 GBP pday was a common/avg rate in 2006/7 10 years ago ( in London ).

JDLove

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

JDLove

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 ...

JDLove

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....

JDLove

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...

JDLove

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

JDLove

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

JDLove

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...

JDLove

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 ...

JDLove

I think I got it working ... I'll test it then post up the TI script for others if they need it
JD

JDLove

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...

JDLove

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.

JDLove

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 "

JDLove

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

JDLove

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

JDLove

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(...

JDLove

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' )...

JDLove

Hi Kyro,

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

Regards
JD

JDLove

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...

TM1 Forum

Search found 41 matches

WANTED: Contract TM1 work

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

Re: Sublime Text TM1 syntax highlighter

Re: Sublime Text TM1 syntax highlighter

Re: Sublime Text TM1 syntax highlighter

Re: Consolidated Financial Statements in TM1 ?

Re: TM1 Blueprints

Re: Modeling HFM in TM1

Re: Modeling HFM in TM1

TM1 Applications or Excel & VBA what say you ?

Re: Putting Expand function to a good use

Re: Putting Expand function to a good use

Re: Adding date in TM1 webapp adds one year

Re: Spreading Hold not visable in Excel 2010 with CX

Re: Spreading Hold not visable in Excel 2010 with CX

Spreading Hold not visable in Excel 2010 with CX

Re: Version / Scenario dimension best practice

Re: Actual and Forecasting

Re: iPhone/Android Testers Needed - Spark Mobile

Re: Consolidated Financial Statements in TM1 ?