SAP Knowledge Base Article - Preview

3677708 - Analysis for office shows format date as "yyyy" instead of real number

Symptom

When opening an Analysis Office report the date format appears as e.g: 01/10/yyyy.

--------------------------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------------------------------

In the AO trace file the AO parameter EnableNativeFormatting  is set to true.

---------------------------------------------------------------------------------------------------------------

SETTING deviating from default value -> Name: EnableNativeFormatting, Value: 'False' -> 'True' #

---------------------------------------------------------------------------------------------------------------

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental". 


Read more...

Environment

    • SAP Analysis for Microsoft Office
    • SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud
 

Product

SAP Analysis for Microsoft Office all versions ; SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud all versions

Keywords

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.