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

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.

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

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