SAP Knowledge Base Article - Public

3308358 - The filter value of the Date dimension is always changed to '1970-01-01' when edit the query for an import job in a model bassed on OData data source in SAP Analytics Cloud (SAC)


  • While editing the query for an import job in the model, the entered date for the filter cannot be updated even after changing and saving it. It was always taking wrong value '1970-01-01'.
  • The data source of the query is OData Services.


  • SAP Analytics Cloud (SAC) Enterprise 2023.2.6
  • OData Services Connection

Reproducing the Issue

  1. Open the model and navigate to Data Management.
  2. Select the import job with issue and click Edit Query.
  3. Change the value of filter [DataName], which DataType=date, and click save.
  4. Edit the query again, when opening it, see that it was taking wrong value 1970-01-01.


This is a product issue.


This issue has been fixed by development.

See Also


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, Odata, Odata Services, Connect, model, job, import job, Tenant, Import, Failed, change, save, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, date, datetype, filter, value , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem


SAP Analytics Cloud 1.0