TM1 10.2 Available for Download

User avatar
George Regateiro
MVP
Posts: 326
Joined: Fri May 16, 2008 3:35 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007 SP3
Location: Tampa FL USA

TM1 10.2 Available for Download

Post by George Regateiro »

Of course they drop it during my year end but it appears that 10.2 is available for download.

http://pic.dhe.ibm.com/infocenter/ctm1/ ... ction.html
Last edited by Alan Kirk on Sun Nov 10, 2013 9:50 am, edited 3 times in total.
Reason: Converted to a sticky for 90 days to allow 10.2 discussions to be centralised
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: TM1 10.2 Available for Download

Post by Kyro »

We've released an overview of the changes here. Please note that there are a lot of changes this time around and for the better in my opinion.

I would say the key things to note are:
  • Single Requests are now multithreaded (divide your view calculation time by the number of CPU Cores you have and thats the time it will take in 10.2)
  • Performance Modeler is ready to replace Perspectives
  • TM1 Web had a complete rebuild for performance and better underlying technology
  • Cognos Analysis for Excel (Cafe) - has been released (separate installer) which supports TM1 and BI Datasources.
We'll be posting 10 articles on different aspects of this new version over the next 10 days. The in-cube calculations and performance testing vs. 10.1 are my favourites so far. Stay tuned.

Cheers,
Ben
David Usherwood
Site Admin
Posts: 1454
Joined: Wed May 28, 2008 9:09 am

Re: TM1 10.2 Available for Download

Post by David Usherwood »

InfoCat's take on the new features is here.
I'd say that Scorecarding is noteworthy as a slicker way to monitor and communicate variances. And Cloud will shake things up somewhat.
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: TM1 10.2 Available for Download

Post by Kyro »

On a related note.

The TM1 Contributor iPad application is out now on iTunes! Its a free application which can be used with TM1 10.2 to contribute to plans within TM1.
Since we don't all have TM1 10.2 servers lying around we have set up a sample TM1 10.2 server which you can gain access to here.

Corporate Travel Planning Sample Application
Image
erik664
Posts: 18
Joined: Fri Mar 08, 2013 6:11 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007

Re: TM1 10.2 Available for Download

Post by erik664 »

I would be interested to see if Perfomance Modeler is actually usable now. I've heard it said that it's being pushed just to move away from Perspectives and spite Microsoft.
User avatar
wissew
Posts: 54
Joined: Tue Jun 17, 2008 7:24 pm
OLAP Product: TM1
Version: 9.5.2; 10.2.2; 11
Excel Version: 2003 SP3 - 2013
Location: Beaverton, OR

Re: TM1 10.2 Available for Download

Post by wissew »

Has anyone gotten Performance Modeler 10.2 to work?
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: TM1 10.2 Available for Download

Post by Alan Kirk »

erik664 wrote:I would be interested to see if Perfomance Modeler is actually usable now. I've heard it said that it's being pushed just to move away from Perspectives and spite Microsoft.
To be fair, that last part you might have heard from me, and that's me reading between the lines. I still think it's a valid assumption though. You could argue the case that moving to "canvases" in the style of Insight makes them less dependent on an external company (i.e. Microsoft) which is also true of their move away from IIS for Web. That one I'll reserve judgement on until I see it in action. However if IBM ever completely breaks the nexus between TM1 and Excel, they'll effectively kill the product. I think that the closer the IBMer is to the user base, the more they know this... what concerns me is that a lot of the allegedly strategic decisions are made some distance away from that level. They may indeed make themselves less dependent on Microsoft but moving to Java makes them dependent on Oracle. And between Bill Gates and Larry Ellison, I know which one I'd least be surprised to find sitting on the throne of Hell with a pointy tail, horns and a pitchfork. And it ain't Gates.

I see nothing in the New Features Guide that suggests that they've done a damn thing about that joke that's being passed off as a TI editor, though. That doesn't mean that they haven't, but it wouldn't surprise me.

I'd love to see for myself first hand but when I went to download 10.2 I was told that our entitlement was invalid (gee, after all those $$$$) and when I went to click on the link to Customer Care (never was a greater misnomer coined) I slammed into a page which read:
Error 400
Invalid request -- completely unable to parse it
What "it" is is unspecified. Merely that not only could "it" not be parsed, "it" completely could not be parsed. And the browser was done. No going back, no going forward. Just that one page telling me that "it" was "completely" unable to be parsed.

I shall be charitable and assume that this is not an example of what I'll find in the All New Web.

When or if "it" can be parsed and I can get the 10.2 download, that is.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: TM1 10.2 Available for Download

Post by stephen waters »

erik664 wrote:I would be interested to see if Perfomance Modeler is actually usable now. I've heard it said that it's being pushed just to move away from Perspectives and spite Microsoft.
I believe Performance Modeller(PM) has been developed, not to spite Microsoft. but rather to convert and capture the Cognos Planning (CP) user base and persuade them to migrate to TM1. Many of the features and concepts of CP have been duplicated in PM, but are used to build much more scalable TM1 structures.

I really like PM, but I have gone to the dark side and mainly do pre-sales demos. My colleagues who develop proper TM1 applications are much more sceptical and have concerns about the efficiency of the PM generated TM1 code for all but the simplest TM1 applications. I hope IBM Cognos remembers the history of CP (you can have a product that looks great but performs poorly) and continues to allow developers access to underlying Rules and TI.

On a positive note I am really impressed by many of the TM1 10.2 features. The multi-threaded calculation will benefit all users to a greater or lesser extent ( I think even those on legacy licensing) and, for those on Enterprise licensing, will finally justify PVU pricing! Goodbye to the forum posts questioning why a 16 core server is running at 6% per core; yes, it should run 16 times faster with 10.2, This is of course subject to testing though our intial results seem to confirm the linear improvement.

The rewrite of TM1 Web and introduction of Café to complement Perspectives should significantly improve web performance (another long standing forum subject) and make browsing much more intuitive. It also shows that IBM Cognos are committed to the Excel interface which is, and always has been, such a strong feature of TM1.

Other stuff such as mobile contribution and scorecards look good but I think are more demoware

Anway, I had better stop there I start sounding like an IBM marketing person. But, I would encourage TM1 users to look at 10.2 and think of reasons why you shouldn't upgrade rather than our normal advice of "is there a reason why you should upgrade?". All subject to testing of course ;-)
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: TM1 10.2 Available for Download

Post by Kyro »

We've conducted some tests on the performance gains under the new version - Results here.

To cut a long story short the performance is enhanced directly by the number of CPU Cores as expected. However, this has only effected the actual calculation of cells - Rule saves and server load take the same time. Data loading was actually faster performing also but not at the same rate.
nick_leeson
Posts: 98
Joined: Sat Feb 11, 2012 11:13 am
OLAP Product: TM1 9x, BPC, Hyperion, HANA
Version: TM1 10
Excel Version: Excel 2003 - 2010

Re: TM1 10.2 Available for Download

Post by nick_leeson »

Thanks Kyro for the results interesting that 50% increase in performance in loading a CSV is not bad and the performance of Cube View Load is great.
I will do some testing later tonight and see how 10.2 performs on a 50 GB model.
Cafe looks interesting and would love to see someone stress test it. Can we use subsets in Cafe ?

The biggie is reuse of approval hierarchies and TM1Web.


Cognos EP guys transitioning onto TM1 have got more goodies again then the TM1 purists. :evil:
karkea
Posts: 18
Joined: Tue May 29, 2012 11:11 am
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2007

Re: TM1 10.2 Available for Download

Post by karkea »

I did also some quick tests with PM, because we have some customers interested using PM by themselves.

PM seems to now include Package Connector to load data through FM models. Unfortunately it generates temporary csv file, which is used in the actual process to load the data. And it generates new temp file each time you want to load the data. Just in couple minutes I was able to generate hundreds of these temporary files. And especially scary is the fact load, which can generate +100Mb temp files. For sure one shouldn't touch these processes with Architect, because PM doesn't use the same package connector model than Architect.

Maintaining processes in general seems to be a bit challenging in PM. I could not for example change the target cube of the process after I had created the process.

I will need to spend some more time with PM in order to be able to decide whether it feasible for production use.
User avatar
garry cook
Community Contributor
Posts: 209
Joined: Thu May 22, 2008 7:45 am
OLAP Product: TM1
Version: Various
Excel Version: Various

Re: TM1 10.2 Available for Download

Post by garry cook »

Anyone got any feedback on stability with the final release? Been waiting on multi threaded queries for a long time and assume the NDA's have finished now from the beta.

TIA
dr.nybble
MVP
Posts: 160
Joined: Wed Aug 17, 2011 3:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2007

Re: TM1 10.2 Available for Download

Post by dr.nybble »

Package extract does not use Package Connector. It builds a report specification and extracts it to CSV as you mentioned.
If it is leaving CSV files lying around after the process executes -- that is a defect.
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: TM1 10.2 Available for Download

Post by jim wood »

Guys,

While I hear what's been said about moving away Microsoft, I don't think this has been done to spite them. Currently (10.1 and below) TM1 has a 64-bit Unix install but if you want to use TM1 Web you need a seperate windows box. With this change I'm guessing that we will see complete server install packages for Unix. Also Apache / Tomcat are much configurable for me than IIS, especially if you consider how tied down the latest version is on 2008 r2,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: TM1 10.2 Available for Download

Post by Duncan P »

A small feature that might escape people's notice but about which I am rather pleased is this

ISUNDEFINEDCELLVALUE
lotsaram
MVP
Posts: 3652
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: TM1 10.2 Available for Download

Post by lotsaram »

Duncan P wrote:A small feature that might escape people's notice but about which I am rather pleased is this

ISUNDEFINEDCELLVALUE
A feature that does make using UNDEFVALS much more useable!

However it does draw attention to IBM's atrocious and obviously not improved record when it comes to product documentation, given that right alongside in the 10.2 reference is the entry for UNDEFVALS which states
IBM TM1 Reference Guide 10.2.0 wrote:It is not currently possible in Turbo Integrator to test for this special undefined value directly. This special undefined value is not the value returned by the UNDEF() Turbo Integrator function. The value returned by UNDEF() is an undefined value used for such things as an attempt to divide by zero, or take the logarithm of an illegal number, etc.
You can indirectly test for this special undefined value as follows ...
:oops:
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: TM1 10.2 Available for Download

Post by Kyro »

Just posted an overview of the new metric cube - check it out here.

Image

We were going to add some more applications to the mobile contributor portal for general access but have run into a minor roadblock.
ThomasCS
Posts: 15
Joined: Tue Mar 02, 2010 9:21 am
OLAP Product: TM1
Version: Since 9.5
Excel Version: All

Re: TM1 10.2 Available for Download

Post by ThomasCS »

I'm very interested in the new TM1 web. Performance (especially websheets) and stability (building from scratch will for sure bring new bugs).

About the new features for Performance Modeler & Applications, I hope those products are now more flexible/mature to be used in Production.
Am I correct that the new cube type can only be created in Performance Modeler and not in Architect?

What is the future of Perspectives? It looks like CAFE is getting pushed as alternative towards endusers.
But what with active forms and websheets and all of their flexibility from development side?
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: TM1 10.2 Available for Download

Post by Kyro »

Yeah, maybe someone should do a performance test of TM1Web 10.1 vs 10.2.

They are certainly getting more mature. Along with the new features are bug fixes and also changes which make the front-end flow a lot smoother for developers. There are things that will always bother me about it but only from a TM1 development perspective and I think thats the mistake, we really need to look at this as its own tool held apart from traditional TM1. I think some of the best practise and time proven development methods in TM1 really don't apply here as they don't need to or they don't make sense. Perhaps approach 10.2 Performance Modeler with that in mind.

True - Metric cubes can only be developed in Performance Modeler.

As for the future I can't say, but I think we should all be getting used to Performance Modeler & Cafe regardless.
ThomasCS
Posts: 15
Joined: Tue Mar 02, 2010 9:21 am
OLAP Product: TM1
Version: Since 9.5
Excel Version: All

Re: TM1 10.2 Available for Download

Post by ThomasCS »

For sure Performance Modeler is a great tool from what I've seen and tested and some day I'll be using it in a project.

My biggest concern is losing the active forms and websheet flexibility in the future without have the tools to fill the gap.
It's just because there hasn't been any improvements/changes on those tools in the latest versions.
Post Reply