Date Format of Dimension Attribute Measures is Different than the Load Format or Cell Data Format (Doc ID 2003814.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Predictive Application Server - Version 13.4.1.11 to 14.0 [Release 13.4 to 14.0]
Information in this document applies to any platform.

Symptoms

Measures of DATE type registered as Dimension Attributes are displayed in Fusion Client with a format (e.g. DateTime format: Sat Sep 28 00:00:00 CEST 2013) different than the format (e.g. NoTime format: 20130928) loaded for those measures. It is also inconsistent with cell-data format.

Steps to Reproduce:

1. Login to Fusion Client and build the workbook.
2. Show a dimension attribute of date type within a view.
3. Notice the date format displayed for this attribute.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms