"Invalid Blank Character in Name" While Loading Data into Hyperion Essbase using IKM SQL (Doc ID 1466181.1)

Last updated on JULY 29, 2016

Applies to:

Hyperion Essbase - Version 11.1.2.1.000 and later
Generic Windows
***Checked for relevance on 21-Jan-2014***

Symptoms

Error while loading data into Hyperion Essbase using IKM SQL to Hyperion Essbase (METADATA):

Essbase Version 11.1.2.1
ODI Version 11.1.1.5.0

Error Message :
-------------------
com.hyperion.odi.essbase.ODIEssbaseException: Cannot build dimension. Essbase Error(1030010): Invalid blank character in name (C:\DOCUME~1\APPODI\Local
Settings\Temp\EssData7587271364853575057.txt) in ESSAPI function adBuildDim

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