How to Zero Out all of the Data in Cognos Planning!

Are You Looking for a Simple Way to Zero Out Data in Cognos Planning Contributor?

Do you need to reset a cube to zero in order to clear out all the data in the contributor so users can start over? Maybe you are updating processes and you require a reset of your cubes in Contributor? Below, we will share how to zero out all of the data in Cognos Planning on a per cube basis only.

It’s an all or nothing option – every cell within a cube will be set to zero. Please note that the option to zero out only a selection of the cube like a version, does not exist. However, you can run an Analyst to Contributor link to zero out a selection of the Cognos Planning Cube. For more information on zeroing out a selection check out this IBM link on how to zero out contributor dcube data on the web. Before you run this process, please ensure your users are ok with a complete reset of the cube to zero.

Steps to Zero Out Data in Cognos Planning Contributor

The first step in zeroing out all of the data in Cognos Planning Contributor is to go to Cognos Planning Contributor Administration. Next, select the appropriate application as noted below. Make sure you have the right application! Then, inside the development folder, go to the import section and select the prepare tab. Next, check the zero data box next to the appropriate cube and click the prepare button at the bottom. These steps are noted below in the screen shot.

Cognos Planning

After you click prepare, the following message will appear.

If you then click on the Job Management folder for the application, you will see the Prepare_Import job running. Once complete, you will need to run a GTP process. (Go to production) by clicking the green arrow at the top. Please note that if you forget to run the GTP process, it will not zero the data out until you do.

ZERO OUT THE DATA QUEUE

There may be a situation arise when you load data via a Cognos Planning Analytics to Contributor link. Then, after you ran the link, you realized you didn't want to process the data all the way to Contributor. Don't worry. You can zero out the data queue. This will basically delete the staged date before you send it to Production. A couple important notes about this process. This should NOT be used in conjunction with the aforementioned Zero Data in a Contributor Model procedure. Reason being that it would result in deleting the import queue created by the previous prepare_import job and the data would not zero.

Steps to Zero Out the Data Queue

The first step is to go to Cognos Planning and then the Contributor Administration area. Then select the appropriate application as noted below. Next, go to the development folder and select import data area. Select the prepared data blocks tab and choose delete import queue. This will delete the staged or prepared data blocks. Also note that a Go To Production process is not required for this action. If you need to, you can fix the data in Cognos Planning Analyst and rerun the Analyst to Contributor link with the good data.

Cognos Planning

Hopefully this helps you understand how to zero out all of the data in Cognos Planning! My recommendation when you do this type of maintenance in Cognos Planning is to always FOCUS! Shut down your email and turn off your phone! I learned that lesson the hard way.

Some food for thought...

If you really want to simplify the maintenance of your budgeting and forecasting models, you should absolutely consider looking at TM1. At Lodestar Solutions, we feel the future of Cognos Planning is in question! Hence, we encourage you to start considering and defining your migration to a better tool. Check out our blog to learn the benefits of TM1 over Cognos Planning.

Lodestar Solutions is wanting you to be educated, so we are creating a library of videos that will help you evaluate TM1. Check out our Move to TM1 Program to get access to our library and don’t forget that there is NO COST TO YOU for this program.

If you have specific questions, please contact us at Coaching@lodestarsolutions.com and one of our analytics coaches will contact you.

If you learned something from this blog, we encourage you to refer back to the previous tips in this series....

Check out Tip #1 on what your future plans should be for Cognos Planning by CLICKING THIS LINK.

For Tip #2 on the questions most asked by Cognos Planning clients, learn more by CLICKING THIS LINK.

Refer back to Tip # 3 on simplifying D-List maintenance by CLICKING THIS LINK.

The previous Tip #4 regarding the re-ordering of your E-List can be found by CLICKING THIS LINK.

For Tip #5 on why your cubes may not be opening, CLICK THIS LINK to learn more.