Controller Database Rebuilds

Our team of Consultants have extensive experience helping existing Cognos Controller customers resolve issues with current usage or application design. We are able to resolve existing structural errors and data issues so that all new outputs are fit for purpose and offer a best practice solution.

Whether you are implementing Group Consolidation through legacy software, your existing database relies on manual workarounds or you aren’t benefiting from automated processes, we have the skills and experience to help.

We can take you from a legacy approach to data collection and reporting to new best practice solution that is more efficient and offers improved reporting outputs.

Our solution

We engineer a database solution which:

  • contains data that reconciles in both prior and current periods to numbers being reported
  • contains data that reconciles with the check rules of Controller, or as a minimum carries known differences
  • contains no structural errors or issues
  • matches current reporting requirements

In summary we offer a best practice solution where no information is lost - the existing Live database simply becomes a read only legacy database connection which can be accessed as necessary.

Success stories

We have successfully helped a leading subsea services provider completely rebuild their Controller and TM1 estate. The group consolidation process had been originally configured in TM1 so a key priority of our rebuild was to put the consolidation process right within Controller. The project was completed on time and in budget and significantly reduced the complexity of their month end process and allowed them to benefit from new automated features.

One of our customers, a leading high street retailer, came to us with numerous issues with the design of their Controller database. We identified the key issues within the existing consolidation process and worked to resolve the problems by building and assisting with the maintenance of a new best practice solution.

We have also worked with a leading steel trading and distribution company to rebuild their Controller database, pushing across elements that work and implementing changes where needed. We also addressed usage and training issues to make sure that the software features were fully optimised.