My Oracle Support Banner

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:

Oracle Fusion Middleware MapViewer - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

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

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
Changes
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.