SAP Knowledge Base Article - Public

3038094 - URL API parameter passing incorrect date format in SAP Analytics Cloud (SAC)

Symptom

The following behavior occurs in SAP Analytics Cloud (SAC):

  • A Date Dimension used as a Hyperlink parameter is not formatted properly

Environment

  • SAP Analytics Cloud (Enterprise) 2021.2

Reproducing the Issue

  1. Create a Story in SAP Analytics Cloud
  2. Insert a widget (i.e.  Chart or Table) with date/time dimensions i.e [MYDATE], which has format MM.DD.YY and one or more measure 
  3. Add a hyperlink
  4. In the properties of the hyperlink set: 
    - Link to / External URL
    - External URL / https://<yoururl>?   [MYDATE] 
  5. Click on a cell, select Navigate to External URL , the [MYDATE] value has not been formatted to YYYYMMDD

Cause

This behavior is intended to be so, the hyperlink is built based on what is displayed on the screen

Resolution

  • For Live BW / HANA Connections: Create calculated dimensions at query level, so that they are formatted according to the destination application / URL  needs 
  • In the External URL creation panel enter the dimension used to format the date

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem

Product

SAP Analytics Cloud 1.0