My Oracle Support Banner

Cast Function Is Adding Decimals To Measure Values After Migrating From OBIEE To OAS (Doc ID 2908866.1)

Last updated on MARCH 14, 2024

Applies to:

Oracle Analytics Server - Version 2022 (6.4) and later
Information in this document applies to any platform.

Symptoms

When using Cast function on Measure column to convert it to char it is displaying decimals.

Analysis with the following configuration:

1. A column with a custom formula with the CAST function.
For example: Criteria tab > {column} > Column Formula: cast(("Measure Column") as CHAR(8))

2. In OAS value displayed as  xxxx.xxx where as in OBIEE 12c it is displayed as xxxx in the results.

Note: In OBIEE 12c the column displays correct value but after migrating to OAS the the column values are adding decimal.

 

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.