Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Invoke Webservice with multiple parameters from OBIEE 11g.

Received Response
32
Views
4
Comments
Nabil RIFKI
Nabil RIFKI Rank 2 - Community Beginner
edited Aug 13, 2024 5:29PM in Oracle Analytics Cloud and Server

Hello,

I have a Webservice that require 7 parameters.

I want to call this webservice from an OBIEE Action.

Steps to reproduce the bug :

In OBIEE, I open an Analysis => Criteria Tab => Drag a drop a column => Column property => Interaction => Action Link

I add an action "Invoke a Webservice"

I put the WSDL file Location, I can then select the operation in my Webservice.

In the "Define Parameter" step, I have 7 lines (as my WebService require 7 parameters), but I notice many bugs

1) All the Parameters have the same name (which is the name of the Webservice operation)

2) When I put a value for a Parameter, this value is duplicated to all the 7 parameters.

It looks like OBIEE is invoking my WebService giving one single parameter duplicated 7 times.

Does anyone already tried to invoke a WebService with multiple parameters from OBIEE ?

Thanks

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    What exact version (including bundle patch) ?

  • Nabil RIFKI
    Nabil RIFKI Rank 2 - Community Beginner

    I tried in OBIEE  11.1.1.7.150120 (Build 150113.1200 64-bit)  and OBIEE 12.2.1.4.0 (Build BIPS-20180409090153 64-bit)

    Both are showing the same issue.

    In OBIEE 11g you can call directly call a WSDL file, while in OBIEE 12c you need first to deploy the WSDL file as a webservice in Weblogic then call the webservice using URL.

    I have tested both methods, both are showing the same issue. When calling the webservice the first parameter is duplicated 7 times.

    The business need we want to implement is the following :

    Users want to enter data in the OBIEE dashboard using WriteBack feature.

    Once data is entered, users want this data to be pushed to Siebel Application using the webservice.

    The webservice has been created on Siebel side with 7 parameters as input (Record_ID + 6 Values).

  • Nabil RIFKI
    Nabil RIFKI Rank 2 - Community Beginner

    Hello Giani,

    Do you have any idea on how to safely implement this ?

    Thanks

  • Gianni Ceresa
    Gianni Ceresa Mod

    I don't have a webservice giving me a WSDL with a method with multiple parameters handy, so can't test.

    If the GUI issues you have are when building your analysis and defining the action, you can definitely have a look at the XML and "fix" things there setting the various things.