Oracle Exalytics OBIEE 112c Integrated With ESSBASE ASO Cube Showing All Zeros For Measure Column

(Doc ID 2309971.1)

Last updated on OCTOBER 10, 2017

Applies to:

Business Intelligence Reporting and Publishing - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.1.0 version, Analytics

When attempting to report on an ASO Cube, see only zeros for data and the following error occurs in the OBIEE query logs at the same time:

ERROR
-----------------------
[2017-04-07T11:10:15.575-04:00] [OBIS] [ERROR:1] [] [] [ecid: d1839dad-7eb7-42f4-9a0c-bb12e3a5b98f-000172f5,0:1:23:5:1] [sik: ssi] [tid: 2ffff700] Network error [111]: Failed to connect to [XXX.xxx.com:1423]Invalid login id - request [Select Application/Database] failedInvalid login id - request [EssLogout] failed [[
Properties: description=<> DbGateway Exchange: XXXXX.xxx.com.Essabse Connection Pool; producerID=0xbf7a0d18; requestID=0x520b000e; sessionID=0x520b0000; userName=weblogic;


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In OBIEE report on the ASO Cube.
2. See values with zero returned.
3. Report on BSO cube, or sample ASO cube works. Viewing the ASO Cube from SmartView works.

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