Oracle Exalytics OBIEE 112c Integrated With ESSBASE ASO Cube Showing All Zeros For Measure Column
Last updated on OCTOBER 10, 2017
Applies to:Business Intelligence Reporting and Publishing - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.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:
[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 : 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;
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.
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