IBM Support

Unable to open Planning analytics BI report URL in Excel

Troubleshooting


Problem

Unable to insert PA BI reports urls as hyperlinks in Excel.

Symptom

Running PA BI report url as a hyperlink from Excel will cause the following message:

Unable to open (complete URL will be placed here). Cannot download the information you requested.

Cause

Details will be provided in the Microsoft article below.

Environment

Running Excel 2016 local version of Microsoft office (365 ProPlus) and Planning Analytics On Cloud 2.0.3

Resolving The Problem

https://support.microsoft.com/en-us/help/218153/error-message-when-clicking-hyperlink-in-office-cannot-locate-the-inte

Based on the article above, we need to either download the Microsoft easy fix tool or manually modify the registry keys.

[{"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Planning Analytics","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.0.3;2.0.2;2.0.1","Edition":"Advanced;All Editions;Standard","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg22011960