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

Last updated on FEBRUARY 08, 2017

Applies to:

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