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

OBIEE Webservices - Help

Received Response
16
Views
10
Comments
3046012
3046012 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:41PM in Oracle Analytics Cloud and Server

Hi All,

Can you please let me know web service name in OBIEE, where i need to know Subject Area, Table name and column name of a report through webservice call?

Thanks in advance.

Regards,

Moses

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    As a starting point, take a loo at this: https://docs.oracle.com/middleware/12213/biee/BIEIT/methods.htm#BIEIT180

  • 3046012
    3046012 Rank 3 - Community Apprentice

    Thank you Joel for the update. I am able to establish a webservice call to OBIEE from my SOPA UI.

    I  am unable find the method name which will let me know the subject area, presentation table name and presentation column name of a report which name i passed as a parameter.

    Can you please suggest.

    Regards,

    Moses

  • Joel
    Joel Rank 8 - Analytics Strategist

    Does it have to be a web service? You can get this information out of a catalog manager report:

    pastedImage_0.png

    Although you'd need to apply filtering by analysis (name) in Excel or DV

  • 3046012
    3046012 Rank 3 - Community Apprentice

    Thank You Joel, but we are looking to automate instead of manual selection, since the above selection is manual. Can you suggest any.

  • 3046012
    3046012 Rank 3 - Community Apprentice

    so thats the reason we are looking at webservices.

  • Joel
    Joel Rank 8 - Analytics Strategist

    As far as I know, there aren't any methods in the webservice to do this. You could automate the method I suggested by doing this by command line using the runcat CLI. You'll probably need to encompass this in a python script to pass analysis name as a parameter and filter out what you don't need in your final output

    This should give you an idea of how to call the runcat CLI:

    Oracle Support Document 2178283.1 (OBIEE 11g/12c: How to create catalog reports only for specific report/folder path in an text file) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2178283.1

  • 3046012
    3046012 Rank 3 - Community Apprentice

    Thank yo Joel,

    when i used the runcat command, it is failing with the below error

    The script looks like this:

    runcat.cmd/runcat.sh -cmd report -online http://localhost:9704/analytics/saw.dll –credentials C:\creds.txt C:\Temp\Analysis_Output.txt -type "Analysis" -fields "Column" "Table"

    The error that I am getting is: "Unable to login to http:/localhost:9704/analytics/saw.dll"

  • Joel
    Joel Rank 8 - Analytics Strategist

    are you running this on windows or linux?

    Linux

    runcat.sh -cmd report -online http://localhost:9704/analytics/saw.dll –credentials C:\creds.txt C:\Temp\Analysis_Output.txt -type "Analysis" -fields "Column" "Table"

    Windows

    runcat.cmd -cmd report -online http://localhost:9704/analytics/saw.dll –credentials C:\creds.txt C:\Temp\Analysis_Output.txt -type "Analysis" -fields "Column" "Table"

    Do you have SSO configured? If so change analytics to analytics-ws

  • 3046012
    3046012 Rank 3 - Community Apprentice

    No Joel

  • 3046012
    3046012 Rank 3 - Community Apprentice

    running on windows