OBIEE Does Not Match Join Column When Using SASS Cube SERVICES 2008 (OVER XMLA) (Doc ID 1560840.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Symptoms

Using OBIEE 11.1.1.6.7 on Microsoft Windows x64 (64-bit) 2008R2

The world map doesl not show the countries in color. It shows all white.

The colors are displayed when the data comes from one supplier but not from another.

Failing example (MS AS)

Theme query [ SAXO_COUNTRY_THEME ]: SELECT /*+ index(MAP_WORLD MAP_WORLD_SIDX) */ ROWID, sdo_cs.transform(GEOMETRY,8307), 'SAXO_BLUE1', COUNTRY, 'T.ALL_CITIES_SMALL', 1, 'rule#0', COUNTRY FROM MAP_WORLD WHERE 's'='s' AND COUNTRY IN (select * from TABLE (:NSDPVLIST) )
.. NSDP keys begin: [[
...[Original Accounts].[CRM Country].&[Afghanistan]

.."[Original Accounts].[CRM Country]"...
..NSDP keys end.

Time spent on NSDP join:0ms. Matches found: 0.

--

Working example (ESSBASE)


Theme query [ SAXO_COUNTRY_THEME ]: SELECT /*+ index(MAP_WORLD MAP_WORLD_SIDX) */ ROWID, sdo_cs.transform(GEOMETRY,8307), 'SAXO_BLUE1', COUNTRY, 'T.ALL_CITIES_SMALL', 1, 'rule#0', COUNTRY FROM MAP_WORLD WHERE 's'='s' AND COUNTRY IN (select * from TABLE (:NSDPVLIST) )
...NSDP keys begin: [[
Afghanistan
Albania
Algeria...
..
NSDP keys end.

...[ SAXO_COUNTRY_THEME ] sql exec time: 4086ms, total time loading 153 features: 8525ms.
Time spent on NSDP join:1ms. Matches found: 153.

Changes

Cause

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