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

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle 9iAS 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 will not show the countries in color. It shows all white

This works when the data comes from ESSBASE but does not render the colors when the data comes from SASS Cube

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.

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