Search found 49 matches

by JDLove
Thu Mar 28, 2024 12:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Financial Consolidation TM1 Sample Module
Replies: 1
Views: 112

Financial Consolidation TM1 Sample Module

Hi TM1ers, I'm tidying up my Dropbox and looking to share a TM1 Financial Consolidation Sample Model in the appropriate platform. I build this maybe 9 years ago, it was mostly build myself with some checking and encouragement from colleagues who I have checked they are happy to share it openly. This...
by JDLove
Mon Nov 13, 2023 9:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to create new Version in QUBEdocs
Replies: 2
Views: 7339

Re: How to create new Version in QUBEdocs

I've asked Keaton on the website :-), waiting for response.
by JDLove
Sun Nov 05, 2023 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW How to make View Filters work together
Replies: 9
Views: 9133

Re: PAW How to make View Filters work together

An update, I ended up reverting to Active Forms as the MDX was taking too long to run.
Good exercise and will benefit in other use cases but for this report/calculator it was terribly slow taking about 30 seconds to refresh.
by JDLove
Sun Nov 05, 2023 9:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to create new Version in QUBEdocs
Replies: 2
Views: 7339

How to create new Version in QUBEdocs

Can some suggest how I can create a new Version in QUBEdocs ? We are running an older version 4.0.1099.0 , I'm not sure if its still supported or by who now. Be worth upgrading if I can find how to do that also. I'm deploying a few new cubes and processes to PROD and some users ref to QUBEdocs for d...
by JDLove
Mon Oct 30, 2023 11:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW How to make View Filters work together
Replies: 9
Views: 9133

Re: PAW How to make View Filters work together

Thanks, this approach works as expected, took me some time to follow the MDX but worth the effort to reuse. I found the link provided and detailed example and workings needed for my understanding. It was a good complete example quite close to what I was wanting. by burnstripe » Sat Oct 21, 2023 5:21...
by JDLove
Mon Oct 23, 2023 8:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW How to make View Filters work together
Replies: 9
Views: 9133

Re: PAW How to make View Filters work together

Thanks for the replies,

Given the support for burnstripe I simply must trial this :-)

Very interesting links again thank you all for those.
Hope this helps others who come across this seemingly simple need in PAW.
by JDLove
Sat Oct 21, 2023 8:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW How to make View Filters work together
Replies: 9
Views: 9133

Re: PAW How to make View Filters work together

Thanks for the reply, another colleague advised me of this approach but I had hoped for something cleaner and able to use the native PAW Dimension selectors/filters in the book. I think I had this demonstrated to me a few years back but I didn't get the full details from them at the time. If not wha...
by JDLove
Sat Oct 21, 2023 4:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW How to make View Filters work together
Replies: 9
Views: 9133

PAW How to make View Filters work together

As a example I have a simple PAW Book with 1 View, I have dragged out 2 dimensions for user to filter the view. 1. Dimension is "Container Size" 2. is "Destination" I want the Destination subset to only show the destinations which have data for that Container Size. I'm reduced to...
by JDLove
Thu Jul 20, 2017 9:12 am
Forum: OLAP Jobs
Topic: WANTED: Contract TM1 work
Replies: 0
Views: 44782

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: 21730

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: 6205

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: 6205

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 don...
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: 6205

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&quo...
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: 14813

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: 4350

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: 4065

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: 4065

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: 2107

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: 13098

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: 13098

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