Symptom
In the Data Analyzer, the data format of the date type dimension does not match the date formatting defined in the user profile.
The BW live, BPC live or S/4HANA live connection is in use.
Environment
- SAP Analytics Cloud (Enterprise)
Reproducing the Issue
- Log in to your SAC tenant.
- Click on your Profile Settings and set the Date Formatting, for example, to yyyy/MM/dd format.
- Open the data analyzer.
- Observe the date dimension members are in a different format, which is not as expected.
Cause
This works as designed.
Basically, in case of Live connection to SAP BW, the recommendation is to use the profile settings defined in the BW backend in order to provide end users most consistent data formats. In SAC, in the profile settings, there are some format options for Date available, which are not supported by the BW server.
Resolution
We recommend to maintain the default date format in your BW backend. It could be an option for you to create an ABAP report running in the backend which automatically specifies the date format for your individual users. Then you do not have to train the users to do this.
If you would like a new SAC feature to provide the users an unified date format across all different backends and data sources, and give users or admins the option to specify a unified date format for all different user scenarios (e.g. in the SAC embedded scenario the SAC profile settings are not supported), this is a new feature enhancement request.
Please create an enhancement request as per KBA 2424376.
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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, 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, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, insight, time, formatting, preference, preferences, BW/4HANA, BW4HANA , KBA , LOD-ANA-DAN , SAC Data Analyzer , Problem