Search found 49 matches
- Thu Mar 28, 2024 12:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Financial Consolidation TM1 Sample Module
- Replies: 1
- Views: 2528
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...
- 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: 7439
Re: How to create new Version in QUBEdocs
I've asked Keaton on the website , waiting for response.
- 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: 9324
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.
Good exercise and will benefit in other use cases but for this report/calculator it was terribly slow taking about 30 seconds to refresh.
- 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: 7439
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...
- 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: 9324
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...
- 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: 9324
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.
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.
- 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: 9324
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...
- 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: 9324
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...
- Thu Jul 20, 2017 9:12 am
- Forum: OLAP Jobs
- Topic: WANTED: Contract TM1 work
- Replies: 0
- Views: 47642
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...
- 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: 24076
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 ).
- Mon Apr 24, 2017 1:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sublime Text TM1 syntax highlighter
- Replies: 6
- Views: 6297
Re: Sublime Text TM1 syntax highlighter
Thanks Paul that was what I missed !
Not the easiest to install, but I suspect mostly it was me not following instructions carefullyDid you install RegReplace? This is required for the convert bit to work.
- Mon Apr 24, 2017 10:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sublime Text TM1 syntax highlighter
- Replies: 6
- Views: 6297
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...
- Mon Apr 24, 2017 6:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sublime Text TM1 syntax highlighter
- Replies: 6
- Views: 6297
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...
- Fri Oct 09, 2015 4:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Consolidated Financial Statements in TM1 ?
- Replies: 13
- Views: 15031
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...
- Tue Sep 22, 2015 12:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Blueprints
- Replies: 5
- Views: 4410
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
- Wed May 20, 2015 2:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Modeling HFM in TM1
- Replies: 3
- Views: 4129
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
Ng Eng Juan, Consolidated Financial Statements (Singapore), McGraw-Hill
- Tue May 19, 2015 6:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Modeling HFM in TM1
- Replies: 3
- Views: 4129
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...
- 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: 2128
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 ...
- 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: 13367
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
JD
- 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: 13367
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...