Services & Specialties
We provide professional management and technology consulting services across a range of performance management solutions in Asia-Pacific countries such as Singapore, Malaysia, Indonesia and Australia using Adept Corporate Performance Management solution (APM):
- Business Analytics, Management Reporting, Dashboarding and Scorecarding
- Business Planning, Budgeting, Forecasting and Rolling Estimates
- Business Process Modeling, Process and Resource Optimization
- Project and Activity-Based Planning and Reporting
- Financial Consolidation and Reporting
- Sustainability Reporting and Planning
- Cost Allocation Modeling
We specialize in using software/cloud services such as IBM Planning Analytics (TM1), IBM Cognos Controller, IBM Cognos Analytics, Envizi and OneStream to develop innovative and value-adding solutions.
As part of our value-added services, we provide the following services:
- Application support service for existing IBM Planning Analytics (TM1), IBM Controller, IBM Envizi, IBM Cognos Analytics and OneStream implementations
- Training services for IBM Planning Analytics (TM1), IBM Controller and IBM Cognos Analytics that focuses on enabling your organisation in realising the full potential of your performance management solutions
- Performance tuning and health check services for your existing IBM Planning Analytics (TM1) implementation
- Upgrade service from existing IBM Cognos Enterprise Planning solution to IBM Planning Analytics (TM1) platform
- Upgrade service to the latest version of IBM Controller, IBM Planning Analytics (TM1) and IBM Cognos Analytics.
- IBM software annual renewal service
If you are interested in knowing more about our services, please contact us through this form.
Training Service: IBM Cognos Controller
We provide customised training on IBM Planning Analytics (TM1), IBM Cognos Analytics and IBM Cognos Controller. The course descriptions are listed below. If you have any training needs, please contact us through this form!
IBM Cognos Controller Course - Application Setup
This training is a 2-day instructor-led course that provides application or project team members users with the skills and knowledge required to setup a Controller system.
| Target Audience | Application Administrator Project Team Members |
| Recommended Prerequisites | Basic knowledge of group reporting and consolidated accounts Basic knowledge of Microsoft Excel |
| Key topics | Company Structures Accounts Structures Form Structures Extended Dimension Structures Linked Structures Submissions General & Other Configurations within Controller |
IBM Cognos Controller Course - Consolidation Workflow
This training is a 2-day instructor-led course that provides application users with the skills and knowledge required to prepare and manage the workflow for consolidation in Cognos Controller.
| Target Audience | Application Administrator Application Users |
| Recommended Prerequisites | Basic knowledge of group accounting Basic knowledge of Microsoft Excel |
| Key topics | Perform foreign currency conversion Perform Intercompany balances elimination Examine automatic journal entries Eliminate Investments Adjust group data via journal entries Consolidated group values Run report and analyze reconciliation and consolidation |
IBM Cognos Controller Course - Import from External Files
This training is a 1-day instructor-led course that provides administrators with the skills and knowledge required to import external files such as files from accounting systems into Cognos Controller.
| Target Audience | Application Administrator IT Personnel |
| Recommended Prerequisites | Understanding of Cognos Controller Structures setup specific to own environment |
| Key topics | Maintain Import Specifications Defining Lookup Tables Using Import Specification Wizard Import Specification for Different Source Formats (e.g. Multiple Columns, Movements, Monthly Values etc.) |
IBM Cognos Controller Course - Report Writing
This training is a 1-day instructor-led course that teaches report authors how to design and generate reports using Cognos Controller.
| Target Audience | Application Administrator Report Authors |
| Recommended Prerequisites | Understanding of Cognos Controller Structures setup specific to own environment Basic Knowledge of Group Accounting Microsoft Excel |
| Key topics | Forms as Report Ad Hoc Reports Standard Reports Customized Reports Excel-Linked Reports Report Books |
IBM Cognos Controller Course - Changes In Structures
This training is a 1-day instructor-led course that teaches Administrator how to make the changes in Controller structures.
| Target Audience | Application Administrator Super Users |
| Recommended Prerequisites | Understanding of Cognos Controller Structures setup specific to own environment Basic Knowledge of Group Accounting |
| Key topics | Changing Account Structures Changing Dimension Structures Changing Company Structures |
Training Service: IBM Planning Analytics (TM1)
We provide customised training on IBM Planning Analytics (TM1), IBM Cognos Controller and IBM Cognos Analytics. The course descriptions are listed below. If you have any training needs, please contact us through this form.
Foundation Skills for End User
This training is a 1-day instructor-led course that provides end users with the basic skills and knowledge to use solutions that are powered by IBM Planning Analytics (TM1). The following topics are for deployment that is using Planning Analytics for Excel (PAfE) Excel add-in. If the model is deployed using Planning Analytics Workspace (PAW) or TM1 Web, we can customise the training content accordingly.
| Target Audience | Budget contributors, reporting users |
| Recommended Prerequisites | Basic knowledge of reporting and planning processes Basic knowledge of Microsoft Excel |
| Key topics | Understanding the basics of TM1 cubes and dimensions Using subset editor to create customised consolidations Exporting cube data into text files Performing data filtering e.g. Top 10 listing Using advanced TM1 spreading functions to populate data Using TM1-Excel formulae (DBRW and DBS) to customise reports and input templates Inserting Excel charts and tables into PowerPoint slides |
Developer Training
This training is a 2-day instructor-led course that teaches appointed administrator and modelers to build TM1 models.
| Target Audience | Administrator, modeler |
| Recommended Prerequisites | Have gone through TM1 Basics for End User training |
| Key topics | Understanding TM1 design principles Performing dimension maintenance using different methods Creating cubes Creating data import using TI process TM1 Rule Writing |
Administrator Training
This training is a 1-day instructor-led course that teaches appointed \administrator and IT support on how to maintain the model and its objects.
| Target Audience | Administrator, IT support |
| Recommended Prerequisites | Have gone through TM1 Basics for End User training Understanding of how the underlying TM1 model works |
| Key topics | Understanding TM1 server architecture Understanding TM1 file structure Performing data and file back up Performing data recovery Performing transaction query Maintaining user groups and user IDs Maintaining security rights Maintaining dimensions |
Health Check Service on IBM Planning Analytics (TM1) Models
Wondering why your IBM Planning Analytics (TM1) model is getting slower? Having difficulty in supporting new requirements from business users? Feeling handicapped by your TM1 solution which is not performing to your expectations?
To protect your investment in IBM Planning Analytics (TM1) and get the best of of this excellent software, we strongly recommend to conduct periodic performance tuning and health check. The main benefits are: improved performance and identifying underlying design issues created by previous consultants. After conducting a health check, we can then present to you a list of action items that can be carried to resolve defects related to the design.
Contact us through this form to find out more!
Upgrade Service of IBM Cognos Enterprise Planning (EP) to IBM Planning Analytics
Your organisation has been using IBM Cognos Enterprise Planning (aka Cognos Planning, or EP for short) for years. As your organisation grows, so does the number of users, the amount of data, and more critically, the complexity of the budgeting, planning and forecasting requirements. Issues relating to performance, scalability and inability to model the solution closely to new and complex business requirements start to surface.
To protect your investment in EP while meeting your business users' expectation and business requirements, one possibility is to migrate your planning models from EP to IBM Planning Analytics (PA) . The main benefits are:
- Better change management process as the look and feel of Planning Analytics interface can be made to resemble EP. This means that the learning curve of your users will be smoother!
- Dimensions and elements can be reproduced from EP to PA. Data can also be migrated over to PA cubes.
- Most importantly, PA allows you to model new business requirements easily through its flexible features. You can also choose to revamp your planning models with more drivers, more complex calculations, more dimensions and much more data without performance degradation!
- More powerful and flexible reporting tools for you to analyse your actuals and plan data! Let's face it, EP isn't great at reporting. And this is where PA shines. We can enhance your planning models into a planning AND reporting platform that users across your organisation can use! One software platform, infinite possibilities.
Our consultants are experienced in both EP and PA. We will be glad to provide a free assessment of your existing EP model and recommend an upgrade approach. Please contact us through this form to find out more!