SAP Knowledge Base Article - Public

2566938 - "Change Data Source" for BW live models, makes charts unable to load in SAP Analytics Cloud

Symptom

  • "Change Data Source" for BW live model, makes charts unable to load.
  • Tables and filters are working fine after changing the source.

Environment

  • SAP Analytics Cloud 2017.22.6
  • SAP Business Warehouse
    • BW/4HANA SPS 4
  • Apache Reverse Proxy 2.4

Reproducing the Issue

  1. Logon to SAP Analytics Cloud.
  2. Create ModelA from QueryA using live BW connection.
  3. Create StoryA using ModelA as datasource.
  4. Add a chart, a page filter and a table to the page.
    CS1jpg.jpg
  5. "Save As..." QueryA without any modification in SAP HANA Studio. Name it QueryA_TEST.
  6. Open ModelA in SAP Analytics Cloud and click on "Change Data Source".
  7.  Select QueryA_TEST for the data source and click "OK".
  8. Click "OK" again when the "List of dependencies" window opens.
  9. Save the ModelA.
  10. Open StoryA and notice that the page filter and the table are loaded, however the chart isn't.
    Cs2.jpg

Cause

  • This is a by design behavior.
  • Copying existing query will create new ID for dimensions and measures so the existing charts in the story won't be able to display the data.

Resolution

  • Saving the story as template resolves the problem.
  • This way you can open the template and save it as a new story after substituting placeholder charts with new ones based on the updated model.
  • For more info on saving a story as a template please refer to: Save a Story as a Template

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, BW, Live, Uncaught, in promise, TypeErrorCannot, read property, supportsHierarchy, of null, , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0