Search
Close this search box.

How to Create a New Database in Planning Analytics as a Service

It is now extremely easy to create a new database in Planning Analytics as a Service. In Planning Analytics as a Service world, we have environments (such as Development, Test and Production) and then at each of those we can have TM1 models. Those models are now called databases. Because they are in a specified environment, your databases can have the same name in each environment. For example, in Development you could have a “Nebula Fit” database and then in UAT also have a “Nebula Fit” database and again in Production yet another “Nebula Fit” database. This means you can easily migrate assets from one to another and they will work immediately because the underlying database name is consistent.

Planning Analytics as a Service

Planning Analytics as a Service is deployed into IBM’s Cloud Pak for Data. This is a fully containerised system that lives in Red Hat Openshift and facilitates excellent performance, high availability, sharing resources and a host of other benefits. It also makes it much cheaper for IBM to deploy TM1 for new clients and for clients to deploy environments and databases very quickly.

How to Create a Database in Planning Analytics as a Service

Time needed: 5 minutes

These steps walk you through how to create a Planning Analytics database (these used to be called models or servers). It will result in a blank, all new TM1 database where you can then create all your dimensions, cubes, processes etc.

  1. Select the Admin tile

    PAaaS Administration Tile

  2. Select the Databases tile

  3. Click the Create button

  4. Enter the database name

    This will be the name that appears to your users for the new Planning Analytics database.

  5. Select the disk space for this database

    This is the amount of disk space assigned to this database inside the Cloud Pad for Data server on either AWS or Azure. It can be adjusted later.

  6. Select the memory for the database

    This can be adjusted later as well

  7. Set the Automatic Backup parameters

  8. Click Create

  9. Wait for it to be Created

Do You Need Help with Planning Analytics as a Service

If you are a bit unsure how to set up Planning Analytics as a Service, reach out to use. We have now worked with a number of clients to get their PAaaS environments setup and humming along sweetly!

  • This field is for validation purposes and should be left unchanged.

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In