Updating IBM PAX Data Source Connections
When you develop a report or query in IBM Cognos Planning Analytics for Excel (PAX) there will be times when you need to run your report against a different environment than what it was built in. For example, you built a report in your DEV environment while you are in the middle of a project and need to have the report run against QA or PROD as your project progress.
The old way when using CAFE in an exploration view was to unhide the hidden rows, click into the data source and select the new environment and cube to run the query against. As of writing of this with testing in Version 11.0.32 we have found that PAX is a little buggy and doesn’t always update your query to the new environment.
With a little poking around and still always learning a few new things about IBM’s Verison 11 release, we found a quick way to update the data source in all worksheets in your PAX and possilby CAFE query you are updating to Version 11.
Step 1: Click on Options
Step 2: In the “IBM” tab scroll to the bottom
Step 3: Click on “Update Connection Utility”
Step 4: Select your “old connection” and the select the “new connection”
Step 5: Validate your reports are pointing to the new data source by clicking on the properties button for each worksheet you want to check.