Aramar
  • About Us
  • Our Team
  • Join the Team
  • News & Events
  • Contact
  • IBM Business Analytics
    • IBM Business Analytics Software.

      • IBM Planning Analytics
      • IBM Controller
      • IBM Cognos Analytics
      • Fast Financials
      • Lease16
      • Supporting Software
      • IBM Planning Analytics.

        IBM Planning Analytics is business performance management software that combines budgeting and AI-enhanced forecasting with intuitive analysis, reporting and workflows.

      • IBM Controller

        IBM Controller delivers accurate, fully auditable financial results, a guided period close user experience, and automatic consolidation and reporting.

      • IBM Cognos Analytics

        IBM Cognos Analytics is infused with AI and offers an intuitive and user-friendly experience.

      • Fast Financials

        IBM Planning Analytics models are traditionally built from scratch but with Fast Financials we have created a solution that offers a different approach.

      • Lease16

        Lease16 is our off-the-shelf accounting IFRS 16 Lease management software solution which allows Organisations to easily manage leasing obligations in full compliance with the IFRS 16 Lease accounting standards.

      • Supporting Software.

        The team at Aramar have been working with Cognos products for many years and have a wealth of experience in implementing, developing and supporting Cognos products.

    • IBM Planning Analytics
    • IBM Controller
    • IBM Cognos Analytics
    • Fast Financials
    • Lease-16
    • Supporting Software
  • IBM watsonx
    • IBM watsonx.

      • watsonx.ai
      • watsonx.data
      • watsonx.governance
      • watsonx Assistant
      • watsonx Orchestrate
      • watsonx.ai

        Train, validate, tune and deploy AI models

      • watsonx.data

        Scale AI workloads, for all your data, anywhere

      • watsonx.governance

        Enable responsible, transparent and explainable data and AI workflows

      • watsonx Assistant

        Conversational AI for fast and friendly interaction

      • watsonx Orchestrate

        Get more time back for things that matter

    • watsonx Orchestrate
    • watsonx.governance
    • watsonx.ai
    • watsonx.data
    • watsonx Assistant
  • IBM Envizi
    • IBM Envizi.

      • IBM Envizi
      • IBM Envizi

        Fully managed platform that simplifies the collection, consolidation, management, reporting and analysis of diverse ESG data sources.

    • IBM Envizi
  • Customer Success
    • Customer Success.

      • Customer Success Programme
      • Customer Stories
      • Customer Success Programme

        All our customers join our success program.

      • Customer Stories

        Don’t just take our word for it…

    • Customer Success Programme
    • Customer Success
  • Services
    • Services.

      • Implementation and Development
      • Cloud Migration
      • Support
      • IBM Licensing
      • Knowledge Centre
      • Implementation and Development

        From practical, hands-on development through to strategic guidance, our team of specialists is here to help.

      • Cloud Migration

        We have unrivalled experience in helping customers migrate their Business Analytics installations to the Cloud and helping them to take advantage of all IBM SaaS has to offer.

      • Support

        We are proud of our dedicated, friendly support desk, providing IBM Certified support and application support.

      • IBM Licensing

        As an Gold IBM partner, Aramar are able to negotiate the best terms with IBM on software licences and can provide wrap-around support to help you get the best from the products you have purchased.

      • Knowledge Centre

        Got a question? Explore the articles in our Knowledge Centre and find the answers that you are looking for.

    • Implementation and Development
    • IBM Cloud Migrations
    • Support
    • IBM Licensing
    • Knowledge Centre
  • Solutions
    • Solutions.

      • Financial Planning and Analysis
      • Financial Reporting
      • Lease Accounting
      • Strategic Workforce Planning
      • Supply Chain Planning
      • Marketing Planning
      • Group Financial Consolidation
      • Financial Planning and Analysis

        Planning Analytics addresses all the traditional problems inherent in spreadsheet models such as the lack of scalability, model fragility, and formulae errors.

      • Financial Reporting

        Reporting can cover Profit & Loss, Balance Sheet, Cashflow, sales analysis, working capital, capital expenditure.

      • Lease Accounting

        Lease16 is our off-the-shelf accounting IFRS 16 Lease management software solution which allows Organisations to easily manage leasing obligations in full compliance with the IFRS 16 Lease accounting standards.

      • Strategic Workforce Planning

        Workforce, headcount and salary planning models built with IBM Planning Analytics are able to meet the needs of both Operations, who are focused on the resources needed to achieve targets, and of Human Resources, who need to balance the demand for resourcing at the corporate level.

      • Supply Chain Planning

        IBM Planning Analytics helps organisations to optimise their supply chain by presenting a single source of truth, unified across inventory management, demand planning, marketing, sales, operations, and logistics.

      • Marketing Planning

        Organisations that use IBM Planning Analytics as the central platform for their marketing plans are able to integrate all their disparate data into a single source of the truth to create a comprehensive view of marketing spend, targets and plans across the organisation.

      • Group Financial Consolidation

        IBM Controller is globally proven across all industries and enterprise sizes to overcome the technical challenges of transforming disparate data into uniform and coherent information needed to produce consolidated financial statements.

    • Financial Planning and Analysis Use Case
    • Financial Reporting Used Cases
    • Lease Accounting
    • Workforce Planning Use Case
    • Supply Chain Planning Use Case
    • Marketing Planning Use Case
    • Group Financial Consolidation
    • Business Intelligence
  • About Us
  • Our Team
  • Join the Team
  • News & Events
  • Contact

Knowledge Centre

IBM Planning Analytics

  • How to: Change the display row limit in Planning Analytics for Excel
  • How to: Mapping a CSV data source directory in IBM Planning Analytics on Cloud
  • How to: Checking whether a Dimension exists in Planning Analytics
  • How to: Change maximum login attempts to Planning Analytics on Cloud
  • How to: Mapping a Network Drive between Live and Development Environments in Planning Analytics on Cloud
  • Aramar Tips: Moving Databases in Planning Analytics
  • How to: Change a Dimension Element Weight in Planning Analytics via TI process
  • How to: Using the While statement Turbo Integrator Process in IBM Planning Analytics
  • How To: Investigating issues using the TM1 Server Log
  • How to: Create Subsets driven by another Dimension in Planning Analytics
  • Aramar Tips: Creating documentation IBM Planning Analytics
  • Aramar Tips: Checking your parameters with a Planning Analytics TI Process
  • Aramar Tips: Using PowerShell in Planning Analytics
  • Fundamentals: Feeders in IBM Planning Analytics
  • Fundamentals: Cube Viewer in Planning Analytics for Excel
  • Fundamentals: DBRW in Planning Analytics
  • Aramar Tips: Analysing Data in IBM Planning Analytics for Excel
  • How to: Create a Dimension in IBM Planning Analytics
  • Fundamentals: What are Dimensions in IBM Planning Analytics?
  • How to: Edit Dimensions in IBM Planning Analytics
  • How to: Create a Cube in IBM Planning Analytics
  • How to: Add a new Element to an existing Dimension in IBM Planning Analytics
  • How To: Resolve ODBC error ‘unable to open connection to database’ in IBM Planning Analytics 
  • Aramar Tips: Working with Subsets in IBM Planning Analytics
  • How to: Check the Security of a Dimension in IBM Planning Analytics
  • How To: Check the version of IBM Planning Analytics for Excel
  • How to: Check and manage your IBM Planning Analytics licence usage vs. your licence entitlement
  • How To: Set up Inactivity Timeout Sessions in IBM Planning Analytics
  • How To: Install Planning Analytics for Excel (PAfE)
  • How to: Find out your Planning Analytics Version using Remote Desktop (Planning Analytics on Cloud)
  • How To: Subscribe to IBM Security Bulletins for Planning Analytics, Cognos Analytics and Controller
  • How To: Find out your Planning Analytics Version using Workbench (Planning Analytics on Cloud)
  • How To: Create a simple hierarchy in Planning Analytics

IBM Cognos Analytics

  • How To: Subscribe to IBM Security Bulletins for Planning Analytics, Cognos Analytics and Controller

IBM Cognos Controller

  • How to: Change the reporting currency belonging to a local subsidiary (or reporting entity) in IBM Cognos Controller
  • How to: Change the reporting currency belonging to the group consolidation in IBM Cognos Controller
  • How to: Effectively structure user security in IBM Cognos Controller
  • How to: Run an internal database optimise in IBM Cognos Controller
  • How to: Schedule an internal optimise in IBM Cognos Controller
  • How to: Check currency translation using a standard report in IBM Cognos Controller
  • How to: Audit the Licenced Number of Controller Users
  • How to: Improve your Controller Excel Report Performance
  • How to: When Does the FAP Publish Client from Controller Need Updating?
  • How to: Drill Data within Cognos Controller
  • How To: Change the method of translation applied to the P&L statement, or create different P&L translation views from the same source data in IBM Cognos Controller
  • Aramar Tips: The Benefits of Using IBM Cognos Controller Web for Data Import via Import Specifications
  • How to: Check when a Company was last updated (and by who) from within IBM Cognos Controller Web
  • How to: Reconcile Data by Company in IBM Controller Web
  • How to: Consolidating a Submission in IBM Cognos Controller Web
  • How To: Fix the Intercompany button not appearing in IBM Cognos Controller
  • How To: Interrogate the backend SQL table using IBM Cognos Controller
  • How To: Log into Citrix for the first time using IBM Cognos Controller on Cloud
  • How to: Check the size of your IBM Cognos Controller database
  • How to: Clear the local cache within Cognos Controller
  • Fundamentals: What are the differences between IBM Controller Web and IBM Controller Classic?
  • How to: Navigate the Backend SQL tables within IBM Controller
  • How To: Subscribe to IBM Security Bulletins for Planning Analytics, Cognos Analytics and Controller

General

  • Aramar Tips: 5 Easy tips to consider when adding commentary to your financial reports 
  • How To: Subscribe to IBM Security Bulletins for Planning Analytics, Cognos Analytics and Controller
View Categories
  • Home
  • knowledge-share
  • IBM Planning Analytics
  • Aramar Tips: Moving Databases in Planning Analytics

Aramar Tips: Moving Databases in Planning Analytics

4 min read

In IBM Planning Analytics Cloud or on-premise, you may need to move databases between environments.   #

We have created a checklist you can use to move your database from production into development, then from development to production. Before running through the checklist, we’d like to mention a couple of structural things. In a TM1 model, we create a few extra folders and subfolders to move objects around. We have a ‘<database name>\MIGRATION’ folder that we use to port objects. A ‘\MIGRATION \IN’ folder to hold objects that we are bringing into the database and a ‘\MIGRATION \OUT’ folder to hold objects ported out of the database.

In addition, we have folders within these for the specific instance of a transfer. We name these in the format ‘yymmdd-<description of the transfer reason’ e.g., ‘220321-Create Month End Reset’. We copy the objects in development into a folder called ‘\INPROGRESS’ to ensure that any ongoing work does not get overwritten. 

 In this example, we want to take a complete database from production into development to have up-to-date data.

Move the database from production into live #

  • Ensure everyone is logged off the model in the production environment. 
  • Commit the production database to disk by running the SAVEDATAALL command. 
  • Stop the production database. 
  • Create a new folder in the <database name>\MIGRATION\OUT directory, e.g., ‘220321-Create Month End Reset Test’. 
  • Copy and compress the database to this new folder. 
  • Restart the database. 
  • Let colleagues know that the production environment is available again. 
  • Copy the backed-up database to a <database name>\MIGRATION\IN directory on the development environment. 
  • Ensure colleagues have logged off the development environment. 
  • Copy any IBM Planning Objects currently in development to a folder, such as <database name>\INPROGRESS. 
  • Commit the development database to disk by running the SAVEDATAALL command. 
  • Stop the development database. 
  • Rename the <database name>\DATA folder to something like <database name>\DATA_yymmdd. Extract the compressed file in the <database name>\MIGRATION\IN folder and populate the <database name>\DATA folder with the objects. 
  • Overwrite the objects in the <database name>\DATA with the objects in the <database name>\INPROGRESS folder so that you have the latest version of the objects in development. 
  • Start the development database. 
  • Check you’ve got up-to-date data in the database and have the objects you have been working on in the database, and they are all OK. 
  • If everything is OK, let everyone working on the development environment know and either delete or move to the <database name>\BACKUP folder the database name>\DATA_yymmdd folder. Otherwise, stop the development database, delete the <database name>\DATA folder you had transferred and rename the database name>\DATA_yymmdd folder back to database name>\DATA and restart the development database, work out what went wrong and restart from the appropriate place. 

Move objects from development to production #

  • Ensure everyone is logged off the model in the development environment. 
  • Commit the development database to disk by running the SAVEDATAALL command. 
  • Stop the development database. 
  • Create a new folder in the <database name>\MIGRATION\OUT directory, e.g., ‘220321-Create Month End Reset’. 
  • Move the IBM Planning Analytics objects that you want to transfer to the production or live environment. 
  • Restart the development database. 
  • Let colleagues know that the development environment is available again. 
  • Make a backup copy of the <database name>\DATA folder or rename it temporarily. 
  • Copy the <database name>\MIGRATION\OUT directory on the development environment to a <database name>\MIGRATION\IN directory on the production environment. 
  • Ensure colleagues have logged off the production environment. 
  • Commit the production database to disk by running the SAVEDATAALL command. 
  • Copy the IBM Planning Objects in the <database name>\MIGRATION\IN folder containing the new objects to the <database name>\DATA folder and overwrite any objects. 
  • Restart the production server. 
  • Check that you’ve got the up-to-date objects in the model and that they are all OK. 
  • If everything is OK, then broadcast to everyone working on the live environment that they can resume and either delete or move to the <database name>\BACKUP folder the database name>\DATA_yymmdd folder. Otherwise, stop the production database, delete the <database name>\DATA folder you had transferred and rename the database name>\DATA_yymmdd folder back to database name>\DATA and restart the production database. 

 

What are your Feelings
Share This Article :
  • Facebook
  • X
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on October 7, 2024
How to: Mapping a Network Drive between Live and Development Environments in Planning Analytics on CloudHow to: Change a Dimension Element Weight in Planning Analytics via TI process

Powered by BetterDocs

Table of Contents
  • In IBM Planning Analytics Cloud or on-premise, you may need to move databases between environments.  
    • Move the database from production into live
    • Move objects from development to production

Our Accreditations and Partners

Aramar works with customers of all sizes, from a range of industries helping them with Business Analytics, Business Process, Sustainability and AI solutions using IBMs leading software solutions.

email contactus@aramar.co.uk

  • LinkedIn
  • YouTube

Registered Address:
124 City Road,
London,
EC1V 2NX

© Aramar 2025. All Rights Reserved.

Terms of use Privacy Policy

Website and Marketing by Unity Online