Automate your work by using the IBM Planning Analytics for Microsoft Excel API

You're a few weeks into your new job, using Planning Analytics for Microsoft Excel and you're noticing that you're creating countless reports and repeating the same multi-step tasks over and over. Fortunately, Planning Analytics for Microsoft Excel features an IBM Cognos automation API, which helps users automate many of their tasks.

You log onto you computer and notice an email from your boss:

Hello,

Good work on the 2014 sales report! I now need you to create some reports for me.

Every year we send out a report to the sales, marketing, and engineering departments.

Can you create a report based on the Goal Input view for each of these departments?

You can find the Goal Input view in the plan_BudgetPlan cube, located inside of the Planning Sample server.

Thanks,

Your manager.

This is the perfect time to use the IBM Cognos automation API. Let's get started.