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 laterInformation 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 |