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