Skip navigation.
spilling the beans

news aggregator

TM1 10.2 with Excel 2013

James Wakefield blog - Sun, 2013-09-22 04:41
The release of TM1 10.2 is very exciting.
Here are some points people may have missed like TM1 now supporting Excel 2013:

TM1 10.2 – Enhancement: Workflow can trigger Processes

TM1 blogs - Fri, 2013-09-20 01:40

In this new version of TM1, 10.2, a new feature has been added to enable the change of workflow state of a node to trigger TI processes.  A preset TI process can be triggered immediate before and immediate after the workflow action.

This feature can be quite useful in a lot of ways, for example, if you have a separate BI report cube setup, when a node is submitted, TI process can be triggered to update the BI report cube without extra actions.  And once all the nodes are locked, then you can be sure that BI reporting cube is ready for reporting, without running extra processes.

Here are few simple steps:
  1. In Application Design mode, double-click on an application that you wish to update.
  2. In the Properties pane, scroll down to select Custom Processes, and click on the Ellipse … to bring up the Custom Processes Settings screen.
  3. Here you can specify which workflow actions can be enabled to trigger a TI process, either immediately before or immediately after the action, as well as the process need to be triggered.

There you go, a very useful feature that requires just a few simple steps.  This feature can potentially enhance and streamline the business planning processes.

Some examples of how this feature can be used:

  • Updating BI Reporting Cube: To ensure the BI reporting contains the latest planning data, TI process can be triggered immediately after a node is committed or submit.  A process is triggered to update a separate reporting cube (it would not matter if it is on the same or different server instance) from the planning cubes.  This would not require separate action to update BI reporting cube (or improve efficiency in case your reporting cube is linked by rules).
  • Import latest actuals from ERP: To ensure the user is seeing the latest and greatest actuals from your ERP, a TI process can be kicked off to import actual financial data from EPR just before user takes ownership.
  • Notify other users when a node is committed: When there are multiple contributors to an application node, can utilise a TI process to notify all relevant users that data is updated, and peer review may be required.
  • Trigger report distribution/printing: When a top consolidation node is locked/submitted against a business unit, it triggers report distribution to all managers for that particular business unit.  If all managers have access to the reporting portal online, this TI process can act as a notification mechanism.
  • Sending reviewer or contributor an email on submit or reject of a node: triggers a process to notify all parties involved.
  • Process to lock/unlock a node: In some cases, the business may want to prevent contributors from updating a node when it has been taken offline.  A process can be triggered to lock access on the server to that specific node immediately after it has been taken offline, and a process to unlock it just before it is brought back online again.

The list can go on and on, it really depends on your business and application, and how this feature may enhance your planning process.


Another remark on default chart settings and visualisation

TM1 blogs - Thu, 2013-09-19 08:05

If you have missed it — there’s a new edition of Stephen Few’s Information Dashboard Design book. A must have and first edition is by far most worn-out Few’s book in my collection. Almost at a point where I’d be embarrassed to ask him to sign it,just had to buy a new one ) Not that we’ll meet any time soon ( Anyways, fantastic read so far!

 Stephen is always repeating that BI vendors should step up and start embedding best practices in their products, not just make proper visualisations theoretically possible, but actively enforce them. As a Cognos BI example, let’s look at a couple of charts. If you like the right one (it’s ”scientifically” better from data/junk ratio), there’s a setting to turn off those black box borders in bar charts in Report Studio right here.   
But by default it’s on and just tell me, how many times did you switch it off?

Sydney Networking – TM1 10.2 Upgrade Special.

TM1 blogs - Thu, 2013-09-19 05:47

October 18th – Sydney TM1 Networking. TM1 Catchup – 10.2 Upgrade Special.

We have arranged a special TM1 catch up dedicated to the 10.2 update. We believe this is the biggest update to the platform since Applix acquired TM1 in 1996.

This is an opportunity to discuss what is new, what we like, what we don’t like and of course how we can make the best of the update over some amazing food and of course beer!

Whether you know all about 10.2 or not much at all – we will share stories and antidotes from experience as TM1 gurus!

Here are a few key points we have picked up from the 10.2 upgrade, if there is something else you would like discussed just let us know.

  • Metric cubes which tie corporate strategy to corporate planning through interactive scorecards
  • More efficient multithreading, which makes TM1 faster (by a factor of the number of cores you have).
  • Cognos Café – a completely new Excel front-end
  • TM1 applications now support multiple uses of a single approval hierarchy

So come along, we’d love to say hi, share a bite and buy you a drink.

The details are:

  • Date: Friday, 18th October
  • Time: 6PM
  • Location: Cabana Bar, St Leonards

RSVP: Please RSVP through the meet-up site here.

We look forward to seeing you there.

Some Excel BI myths debunked – #5 Real-time data exploration

More information per pixel - Wed, 2013-09-11 07:33
#5: Lack of Real-time data exploration

The argument is often made that Excel is too inflexible to answer spur of the moment questions quickly and effectively. The scenario given is that you’re in a meeting with your Excel workbook, and someone asks a related question not currently accounted for. How embarrassing to have to look at your back up folder of printed Excel workbooks… Really? It may escape the attention of some, but Excel is actually an electronic product too so as a first point you wouldn’t need to dust off an enormous binder of printed reports.

That aside, the overall argument has some merit in specific cases. If Excel is acting as both the datastore and the presentation tool you have a problem. If the data you need isn’t in the workbook, you’re bang out of luck.

There are two key requirements to address the issue in Excel. Firstly the data needs to be stored outside the workbook; in the case of XLCubed that’s in AS cubes or tabular models. This means when the data isn’t currently visible in the workbook it can still easily be queried and brought into play.

Secondly, while it’s a huge step having the data in a cube, that in itself isn’t enough. You need to be able to get it out quickly, easily and flexibly and to display it as information rather than just data. There are significant limitations with pivot tables when used to report on a cube and XLCubed addresses these while adding a lot more capability on top. The additional data you need to answer the question is readily available, and you have tools to do something meaningful with it using slice and dice tabular reporting, interactive charting and straightforward user calculations.

So when someone asks the question in meeting, you can explore it interactively and on the spot. And in Excel.

Cognos TM1 10.2 released, Cognos BI 10.2.1 got FP1

TM1 blogs - Tue, 2013-09-10 13:18

A short product update notice:

Cognos TM1 10.2 is out

TM1Tutorials are the first with the list of new features, congrats!

A whole bag of candy, notably:

  • Performance enhancements: given that TM1 in the cloud will become real with this release, there must’ve been another major update to locking model. I would doubt it’s possible to have server-wide locking operations and think TM1 is cloud-ready, so changes must’ve been massive. So new locks — new contention bugs, yahoo!
  • TM1Web totally rewritten to Java: Finally you don’t need Windows at all and can use AIX/Linux for all components. Go blue! Did I mention bugs already?
  • Contributor iPad app: for whatever reason was the main thing I’ve heard rumours about for year at least
  • Data flow diagramming in Performance Modeler: looks like I can finally put tm1mn to rest. And Performance Modeler is becoming the main modelling tool, I’d guess we’ll all be reminiscing about Architect over beers in just a few years )


Cognos 10.2.1 Fp1 is out

Just randomly found it at Fix Central. Am I the only one who wants an ability to subscribe to fix central updates instead of searching every now and then?

Fix list is usual IBM’s “Page unavailable” right now, so I’m not really sure what’s changed. I’m sure that we’ll know soon.

I’m having issues with 10.1.1 DQM on TM1 reports after 10.2.1 upgrade, hope that this FP will alleviate them )

Update: FP1 didn’t help, but now I at least have an idea of what’s happening with my reports:

It’s a 10.2.1 BI new feature called LOLAP (I’m not joking you, it’s really called Local OLAP, honestly) and I’ve already seen underfed cells causing report issues where there were none previously. And that’s not all of it, MDX parsing changed as well. Am I happy? Oh, I’m absolutely blown away, new parser, DQM reports not working after upgrade, data missing where it was before — it’s just like Christmas came early!

RT @Easalydone: Twitter is way better when you can use these ✋❤♨™1⃣

Twitter TM1 - Mon, 2012-06-11 07:13
RT @Easalydone: Twitter is way better when you can use these ✋❤♨™1⃣

Twitter is way better when you can use these ✋❤♨™1⃣

Twitter TM1 - Mon, 2012-06-11 07:13
Twitter is way better when you can use these ✋❤♨™1⃣

Canada - Cognos 8.4 BI / 10 BI / TM1 online training - We do provide Online training on the following Technologies:

Twitter TM1 - Mon, 2012-06-11 07:13
Canada - Cognos 8.4 BI / 10 BI / TM1 online training - We do provide Online training on the following Technologies:


Twitter TM1 - Mon, 2012-06-11 07:13

#TM1 A full day. Morning church, afternoon installation of new pastor, evening presentation at pot-luck

Twitter TM1 - Mon, 2012-06-11 07:13
#TM1 A full day. Morning church, afternoon installation of new pastor, evening presentation at pot-luck

RT @x___COURTNEY: TM1:O3 (:

Twitter TM1 - Mon, 2012-06-11 07:13
RT @x___COURTNEY: TM1:O3 (:

RT @103_SayNoMoe: ™1:03

Twitter TM1 - Mon, 2012-06-11 07:13
RT @103_SayNoMoe: ™1:03

“@_mysecretispink Tm1:03❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤”

Twitter TM1 - Mon, 2012-06-11 07:13
“@_mysecretispink Tm1:03❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤”

When all my followers tweet TM1:03 !

Twitter TM1 - Mon, 2012-06-11 07:13
When all my followers tweet TM1:03 !
Syndicate content