SAP Knowledge Base Article - Public

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


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

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


  • 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


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


  • 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.


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 , Story Design & Visualizations , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem


SAP Analytics Cloud 1.0