SAP Knowledge Base Article - Preview

3320190 - Date format issues for different regions in Analysis for Office

Symptom

There is a date format on database side and when displaying this date in Analysis for Office, depending on the region, this date can be either displayed as DD/MM/YYYY or MM/DD/YYYY and when changing its format manually to the one displayed on database level, the following warning comes in:

  • "All selections for characteristic DATE_SQL are invalid and have been discarded".

The issue is placed when using F4 help and all other prompts related to variables.


Read more...

Environment

  • SAP Analysis for Microsoft Office
  • SAP Analysis for Microsoft Office 2.8

Product

SAP Analysis for Microsoft Office 2.8

Keywords

AllowLiteralMemberSelectionsInVariablesHana, DATE_SQL, invalid and have been discarded, date format, region, All selections for characteristic, variable, F4 help, maintain, setting. , KBA , BI-RA-AO-XLA , Excel Addin , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.