InfoCube and Daptech to Merge

InfoCube, a Sydney-based management accounting and business analytics specialist, and enterprise planning software experts Daptech will merge their businesses to create InfoCube Consulting (Australia) Pty Ltd.

Commencing trading on July 9, the new entity will continue to provide clients such as Woolworths, Goodman Fielder, News Limited, Schneider and Hunter Douglas with superior Cognos service and solutions.

InfoCube founder and managing director, John Vaughan said the merger would complement the strengths of both companies.

“InfoCube has a strong history as a management accounting consultancy specialising in IBM’s Cognos Business Analytics solutions. Daptech, whose experts are also accountants, has great track record as Cognos TM1 Enterprise Planning Software experts.

“Merging is a natural fit for both business and ultimately will enhance the service we supply our clients as we deploy even greater Cognos powered solutions through their CFO offices,” said Vaughan who will be Managing Director of the new business.

The new organisation will continue to have a Sydney focus providing sophisticated Cognos solutions to their combined client base. This activity will focus on management consulting over the IBM Business Analytics suite, managed services for the Cognos Business Intelligence and Performance Management products, training for those products and helping clients manage their IBM software licenses and renewals.

Ben Hill, Director and Principal Consultant adds “we are really excited by the opportunities this opens for us, especially building on the excellent reputation InfoCube has across the entire Cognos suite within the Office of Finance”.

For more information please contact John Vaughan at 0418 634 652.

about infocube

InfoCube is a Sydney based management accounting consultancy, specialising in applying IBM Cognos and Wherescape technology for accounting and finance solutions.  Our primary area of expertise is Corporate Performance Management, including:

  • Rolling Forecasts,
  • Budgeting,
  • Planning,
  • Data Warehousing,
  • Management Reporting,
  • Scorecards and Dashboards,
  • Analysis,
  • Business Intelligence,
  • Consolidations, and
  • Financial Statement Reporting

about daptech

Daptech is a management consultancy firm in the heart of Sydney. We are passionate about business intelligence delivered on the IBM Cognos TM1 platform and strive to share knowledge of such solutions to boost ‘Best Practice’ TM1 implementations.


TM1 Perspectives (for Excel) Report Methods

Here is another minor extract from TM1 training material. We talk through the common sustainable reporting methodologies within TM1 Perspectives for Microsoft Excel. These being:

  • Static/Standard Reporting
  • Active Form Reports
  • Filter Reporting
  • MDX Reporting
  • VUSLICE Reporting

This isn’t an exhaustive list, but we believe these are reporting styles TM1 Consultants should at the very lease know of.
The common methodologies for reporting from TM1 Servers within Microsoft Excel:

NameDescriptionUsage Example
StandardThe default TM1 in Excel Reporting Method. No items on the report change apart from the report parameters (SUBNM’s) and the resulting data cells (DBRW’s).Any basic report which doesn’t need zero suppression of report elements can be made using this method. This is not however very ideal for detailed Profit & Loss or Trial Balance Reports as these may display different accounts based on the chosen Department.
Active FormThe IBM Cognos Approved method for Dynamic Reporting. Active Forms were introduced in version 9.4 of TM1 and allow Level Based Formatting, Expression based Subsets and Double Click Element Expansion.Zero Suppressed dynamic reporting strictly based on Dimension Element Structures. We recommend this format of reports when you require double click Element expansion. Be sure to add a “Refresh” button/textbox to the report and assign the TM1 Macro “TM1RebuildCurrentSheet” to it as some versions have bugs when refreshing using the “F9” Key (This isn’t a problem with TM1Web).
Filter ReportThis reporting method is based on a Standard TM1 Report but with an Excel Filter applied (possibly on a hidden column). A little macro is assigned to a “Refresh” button which will remove the filter, refresh the data then add the filter again.
Note: This report style doesn’t allow double click expansion.
This is great for custom filtered groupings. Blocks of reports can be grouped under each other and use the same filter. Reports are chart safe as rows aren’t ever deleted (as in Active Forms), they are just hidden.

Combining this style with Selectable Group Elements) (return children via ELCOMP) or Subsets (return members via SUBNM) adds a lot of additional functionality.

Ideal for Budget entry reports, Profit & Loss, Balance Sheet etc.

MDX ReportThis is a programmatic solution in VBA (Macros) where TM1 is queried using the Multidimensional Query Language (MDX). The results of the query are output to the worksheet (Read-Only Report) or sometimes are used to write DBRW Formulas which provides a Write-Back enabled suppressed report.This is typically used for large reports which required suppression of over a thousand or more elements. An example where this technique is recommended would be a Salaries & Wages Employee Report for a selectable department within a large enterprise (1000+ Employees).

This kind of report requires an advanced TM1 Specialist to build but is very efficient and performs well.

VUSLICEThis is also a programmatic solution which utilizes a predefined cube view and the TM1 “VUSLICE” macro function. The result isn’t formatted nicely but can be via VBA Coding.This kind of Report is used less and less as Active Forms and Filtered Reports can do a better job and are much easier to create.

Additional Information can be found in the TM1 Reference Guide Document provided by IBM Cognos.

This is probably good ground to expand and add articles to TM1 Tutorials with, How to build reports using each of these styles. Please let me know via comments if I have missed any Reporting methodologies when using IBM Cognos TM1 within Microsoft Excel.