My Oracle Support Banner

MDX Data Extraction Query in ODI is Not Extracting Decimals and Figures are Being Rounded up (Doc ID 2008151.1)

Last updated on JUNE 22, 2018

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

1. When data is extracted directly from an Essbase cube with an MDX data extraction query then floating point data is being extracted correctly e.g. if 11.9 exists in the Essbase cube then 11.9 is being extracted.
2. When the same MDX data extraction query is run in an ODI interface against the same Essbase cube though then values are getting rounded e.g. if 11.9 exists in the Essbase cube then 12 is being extracted.

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


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