OBIEE and WFS Theme - Layer key is missing

Question

Hi all,

have somebody experiences with WFS themes and OBIEE?

I create a WFS theme in MapBuilder, then I can import it in OBIEE as a new layer, but I cannot find any setting to get the “Layer Key” in OBIEE “Edit Layer”-window.

Is it even possible to use WFS themes and OBIEE? I cannot find any documentation nor MOS Note nor Blog entry for this topic.

Best regards

Gerd

Gerd Schandert · Answer

With a little help from Oracle, we found the correct settings.

We built the WFS Theme with the wizard and have used the following URL:

http:// ... /WFSServer?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetCapabilities

After the wizard the URL must be truncated to the following length in the WFS-Theme properties:

http:// ... /WFSServer?

Furthermore, in our case the output format must be manual set to “GML2”.

With these settings, the Layer-Key was displayed in Oracle BI.

[Deleted User] · Answer

Ts ts ts schön sprechen, Gerd :-P

Gerd Schandert · Answer

After an half day of testing with this undocumented feature, I can only think of WTF