TM1 Utilities

Advertisements, add-ons and other commercial information
Post Reply
User avatar
paulsimon
MVP
Posts: 552
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: 10.1.1 and 10.2.2
Excel Version: 2013

TM1 Utilities

Post by paulsimon » Thu Jun 25, 2015 11:45 pm

This Excel Add-In includes a range of over 40 utilities to help you maximise your investment in IBM Cognos TM1 or IBM Cognos Express. Highlights include:

• Reporting
o Update DBRW formula when a new dimension is added to a cube
o Hide Workings, Freeze Panes and Protect the sheet which one click, before publishing your spreadsheet report
o Find the source of errors in DBRW formula
o Generate TM1 Spreadsheets for each Dept, etc, and Email them out
• Loading
o Generate a Template Loader
o Copy spreadsheet Email attachments to a folder
o Load data from all spreadsheets in a folder into TM1
• Impact Analysis
o Find out which Text and Excel files reference a given cube, etc.
• Replacer for Text and Excel files eg replace Dev Server with Prod Server
• Regression Testing eg Development vs Production
o Generate a sheet for the Default View on each Cube
o For example, run on both Dev and Prod for comparison
o Report differences in these or any other spreadsheet reports even BI reports
• Document
o List Cubes, their Dimensions, and Measures
o Generate an indented dimension hierarchy
• System Utilities
o Clear TM1 Cache to get Excel back in step with TM1
o Clear Clipboard to resolve annoying cannot empty clipboard errors
o Automatically set Excel Options such as no recalculation before save.
• Develop
o Can’t delete a Subset because it is used by a View? Find out which View.
o Generate TI Create Script for all Cubes and Views
o Generate TI statements to Add Cube Dependencies from TM1 Server log
o Scan TM1 Server Log for TI Calls
o List Chores, Run Times and Frequencies
• Additional Excel-TM1 Functions, such as ELISANC_zTD
• Includes TM1EasyAPI
o Provides an Object Model over the raw TM1 API

• Easy deployment - all pure VBA so no installation process is required

Download your trial version from www.successcubed.co.uk now!

Contact us at sales@successcubed.co.uk

Paul Segal
Community Contributor
Posts: 229
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: TM1 Utilities

Post by Paul Segal » Wed Aug 05, 2015 9:18 am

Am I missing something Paul - can't see a trial version on your site?

Regards
Paul

User avatar
paulsimon
MVP
Posts: 552
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: 10.1.1 and 10.2.2
Excel Version: 2013

Re: TM1 Utilities

Post by paulsimon » Sat Oct 10, 2015 10:36 pm

Hi Paul

Sorry we were having some problems with the web hosting service, but the product page is there now. You can download an evaluation version.

Recent enhancements include :
  • Generate Cube and View Create TI statements for a selected list of Cubes instead of all Cubes.
  • Remove Conditional Formats from all Active Form Data Ranges on a sheet, to get over the bug where the Conditional Formats from the Format Range can get duplicated in the Data Range every time you Rebuild the Active Form.
  • Find Cubes using a given Dimension.
  • Generate Application Shortcuts for TM1 Objects which can then be dragged into File System Application Folders - somewhat faster than dragging in Perspectives.
  • Deactivate Chores before starting the server, eg when you don't want any chance of Chores running on a Dev Server
Regards

Paul Simon

Post Reply