OLAPObjects for TM1 is a flexible and extensible platform that hosts a growing list of products:
| Web development from Excel | Financial Applications |
| OLAPObjects Publisher | OLAPObjects Journal Entry |
| OLAPObjects Automated Eliminations | |
| General Utilities | |
| OLAPObjects Data Pipeline | Customized Development |
| OLAPObjects Administrator | OLAPObjects Rapid API |
Click on a product to read more about it.
With OLAPObjects for TM1 you can provide secured, fast, live access to Applix TM1 servers using user-friendly Microsoft web technology, tailored to specific requirements. Legions of workbooks can be replaced with one simple web-based information portal, with user-friendly navigation tools that will appeal to an entire enterprise. With its patent-pending Adaptive Inflation Technology ®, OLAPObjects for TM1 is the most flexible, cost effective solution to transforming an TM1 application into a corporate information powerhouse.
Click here to find out more about the OLAPObjects for TM1 platform.
OLAPObjects Publisher is a client
side product that loads into Microsoft Excel as an add-in and enables you to
build high performance secure web applications consisting of integrated
interactive reports and sophisticated input schedules.
It provides you with tools that empower you to develop and maintain a complex
TM1 web site, leveraging all the skills you already have as an TM1 power user,
and requiring few new ones.
OLAPObjects Publisher is distributed
free with any purchase of OLAPObjects for TM1.
Click here to read more about OLAPObjects Publisher.
OlapObjects Journal Entry is a web application that leverages OLAPObjects for TM1 to provide an easy to use, controlled, and auditable way of posting DR/CR adjustments to Applix TM1 cubes through a web browser interface.
| Easy set up of any TM1 cube to accept journals | One or more TM1 cubes can be configured to accept journal
entries. Configuration is managed over the web through the Internet Explorer
browser. The journal entry module can be configured with specific settings, for example whether your base time elements are year to date values or monthly values, and whether credits should be shown as positive or negative values. These settings are controlled by the administrator. |
| Built-in controls | There are built-in controls to ensure that journal entries cannot be posted until they are balanced, i.e. total debits must equal total credits. |
| Intuitive, web based interface | Configuration as well as the posting of journal entries takes place purely over the web, in Internet Explorer. |
| User defined journal span | Entries can only be posted to entities that the administrator
has granted access to. The administrator has further control in that s/he
determines which TM1 cubes in the TM1 database can receive journal entries, and
which dimensions within those cubes the entries can be posted to.
A typical scenario is where journal entries can only be posted within a division, time period and version (i.e. actual, budget, forecast etc.), while for a company that reports by cost center, that dimension too may be configured to accept journal entries. |
| Full support for recurring and reversing journals | Journals can be grouped and easily retrieved for future reuse, to save time and re-keying. Journals can also be easily retrieved for reversal if necessary. |
| Journals may be posted individually or as a batch | One or more journals may be entered for posting at one time. Once posted, the effect of the journal entry is visible immediately in TM1. |
| An audit trail maintained in any ODBC SQL database | An audit trail of every journal transaction is recorded in an ODBC compliant database of your choice. Out of the box a Microsoft Access database is provided for this purpose, but it can easily be configured to write to any ODBC compliant relational database including Microsoft SQL Server, Oracle and DB/2. |
| Standard journal entry reports included | The system includes a set of standard journal entry reports. |
| Custom journal reporting | Custom journal reporting can be done against the relational database record, using any relational report writer including Crystal Reports. |
| Ability to export journal entries to general ledger systems | The system can be configured to extract journals in any text format for posting to most popular general ledger systems. |
| Exploits full TM1 security | The posting of journals is fully subject to TM1 security. |
Inter-company eliminations must be applied so that meaningful consolidations are calculated, no matter where in the organizational hierarchy it is viewed from.
Thinking of the organizational hierarchy as a tree-like structure, elimination companies are set up at each fork in the branch to net out eliminations up to that point. When viewed from the top of the hierarchy, representing the entire organization, all inter-company transactions will have been eliminated, giving a true consolidated picture of the financial results.
With the OLAPObjects Automated Eliminations module this structure can be easily configured, and the process of calculating eliminations can be initiated from a web page, but only by a person with the appropriate security. As soon as eliminations have been calculated, their effects are visible at every level in the organizational structure, as well as at the top consolidated level – once again leveraging iTM1’s powerful on-the-fly consolidation and calculation capability.
Since Journals are created in OLAPObjects Journal Entry, these entries can be reported along with any other journals posted by the Journal Entry module.
Do you have business units around the world using their own financial software and chart of accounts, that need to submit monthly data to your corporate office for consolidation in TM1?
OLAPObjects Data Pipeline is a utility for uploading data into a TM1 database over a secure web page on an intranet or the internet. The data that is uploaded resides in a batch file. This upload file is usually created by taking a flat file extract from a financial software system, and then transforming it into a TM1-friendly XML format using an Excel workbook which is also part of the utility. Organizations that do financial consolidations in TM1 will benefit from using OLAPObjects Data Pipeline if:
Using the OLAPObjects Data Pipeline module is a simple four step process, all carried out at the remote location:
With the OLAPObjects Rapid API you have the ultimate in flexibility and extensibility, for building the TM1 web site of your dreams! As the core of the OLAPObjects for TM1 platform, the Rapid API gives web programmers with Active Server Pages (ASP), Javascript, XML, .Net and related expertise access to an easy to use, secure and fast object oriented model of TM1.
Custom developed web applications built using the Rapid API can be seamlessly combined with web applications built using OLAPObjects Publisher, or with any of the other OLAPObjects for TM1 products.
The Rapid API comes with a detailed on-line help file that lists all objects, methods, properties and events available to the programmer, together with abundant code samples. With it, your web programmers, our web programmers, or those of one of our partners - can combine TM1 data and meta-data with any other data, control, or website imaginable, with ease.
Click here to visit the OLAPObjects Gallery, a demonstration site of applications that were custom developed using the OLAPObjects Rapid API.
OLAPObjects Administrator is a secure web based tool designed for managing large numbers of TM1 clients (users) and client groups, from a browser. With it, an administrative user will be able to to to a web browser and: