3095888 - Error "Input has an invalid format" when entering a value with special characters in a variable in Analysis Office

Symptom

The error below occurs when trying to manually enter a value with special characters directly in a variable in Analysis Office (either in prompts of a query or in a planning sequence):

--------------------------------
Input "XYZ!" for <VARIABLE> has an invalid format
(com.sap.ip.bi.bics.dataaccess.consumer.impl.base.RequestedObjects-InvalidFormat)
--------------------------------

Note: "XYZ!" is just an example of a value with special character.

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Product

SAP Analysis for Microsoft Office all versions

Keywords

invalid, not allowed, input, planning, not able, special, character , KBA , BI-RA-AO-XLA , Excel Addin , Problem

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.