Content from IBM Planning Analytics is not executing through Digital Hive

Content from IBM Planning Analytics is not executing through Digital Hive

Question

The IBM Planning Analytics connector has been configured and we're able to index and browse the IBM Planning Analytics content, but when trying to launch a websheet, cube view, or PAW book, a grey screen with an unhappy face is returned. Looking at the Chrome Developer tools, this error is visible on the Console tab:  

Answer

This error occurs as a result of a misconfiguration on the Planning Analytics server. To remedy this issue, a change to the paw.ps1 (Windows file name) is required.
  1. On the Planning Analytics server, navigate to the <paw_install>/config directory
  2. Open the paw.ps1 file in a text editor
  3. Add or edit this line to the file $env:X_FRAME_OPTIONS="*"
  4. Add or edit this line to the file $env:API_ALLOW_ORIGINS="*"
  5. Add or edit this line to the file $env:CSP_FRAME_ANCESTORS="https://*.domainname.com:9443" replacing domainname with your domain and 9443 with the port number that Digital Hive is running on. If you want further lock down the policy, you can replace the * with the Digital Hive servername.
  6. Save the file
  7. From the <paw_install> directory, launch a Powershell window and run ./Start.ps1
  8. Press Enter to accept the default of not installing or updating the Planning installation
  9. Press Enter to accept the default to start the Planning administration tool
  10. When the IBM Planning Analytics Workspace Administration Tool launches, press Validate
  11. Press OK if everything validates ok
  12. Press Update to reload the configuration
  13. Change views to the Status tab
  14. Press Restart
  15. Once Planning has restarted and can be accessed through a web browser, launch Digital Hive
  16. In Digital Hive, execute the Planning Analytics content and the execution should complete successfully
In addition to the changes above, these settings must also be in the <tm1web_install>\webapps\tm1web\WEB-INF\configuration\tm1web_config.xml file

<add key="CrossDomainAccessList" value="*" />

<add key="X-Frame-Options" value="2" />

If these entries had to be modified, the TM1 web service, IBM Planning Analytics Spreadsheet Services, will need to be restarted.

    • Related Articles

    • Connecting to IBM Planning Analytics

      Question How do we connect Digital Hive to IBM Planning Analytics? Answer As a Digital Hive administrator, connecting to IBM Planning Analytics can be accomplished via the following steps: Open the Digital Hive Control Center Click on the Connectors ...

    • How to 'Enable' Connector Content Within Digital Hive

      Question Once the connector parameters for a content system have been successfully applied, how do I select the desired content from the source to appear within Digital Hive? Answer As part of the connector creation process, once the required ...

    • Connecting to IBM Cognos Analytics

      Question How do we connect Digital Hive to IBM Cognos Analytics? Answer As a Digital Hive administrator, connecting to IBM Cognos Analytics can be accomplished via the following steps: Open the Digital Hive Control Center Click on the Connectors and ...

    • Embedded IBM Cognos Analytics Content is no Longer Visible

      Question When viewing a Hive page that contains embedded IBM Cognos Analytics content, the Cognos content is not displayed. Answer This can occur in environments where object names in IBM Cognos Analytics can change. By default, Digital Hive uses the ...

    • Using IBM Cognos Analytics APIkey Authentication

      Overview As of the Digital Hive 2024.2 release, it is possible to leverage API keys generated in IBM Cognos Analytics, to secure and access Cognos content. This method of authentication should be considered when traditional Single Sign On options ...