OBIEE Webservices - Help

3046012

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

Joel Acha

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

3046012

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 Acha

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

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

3046012

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

3046012

so thats the reason we are looking at webservices.

Joel Acha

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

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 Acha

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

No Joel

3046012

running on windows