OTBI and OBIEE

Muthu S

Using soap service, trying to delete a report. For example used the below path which exists in the OTBI report in that location. But keep getting "Object or shortcut expected: /shared/Custom/Financials/Test Workflow Notifications/Budgetary Control/Budget Override Taken Notification.xdo". Which ever report I try getting the same, if I create a shortcut for the report and use that path it's able to delete it. I am using the WebCatalogService.deleteItem to achieve this. Is this correct or do we need to use a different operation to remove an item ? I am getting the same response both in the cloud OTBI and in OBIEE as well. Any input will be great.

<v12:path/shared/Custom/Financials/Test Workflow Notifications/Budgetary Control/Budget Override Taken Notification.xdo</v12:path>v12:path

JohnW-Oracle

Hello @Muthu S ,

Thank you for the question.

There is a good KM Article on SOAP requests: Examples of "webCatalogService" Webservice Methods in Oracle Analytics (Doc ID 3018011.1)

I don't specifically see: WebCatalogService.deleteItem

This question should be posted to the OTBI forum here for additonal information: https://community.oracle.com/products/oracleanalytics/categories/otbi .

Hope this helps.

Regards,

John

Gianni Ceresa

Hi @Muthu S ,

The deleteItem method definitely exists in the WebCatalogService (and was there already many years ago, it isn't something new).

I don't know the full call you are doing, but because you said that by creating a shortcut (a catalog shortcut) you can successfully delete the shortcut, I would say your call syntax is correct.

Now the thing to verify, and that could explain the issue, is that you are trying to delete a Publisher object. The WebCatalogService doesn't always work fully on Publisher objects. Publisher has its own webservice, could you maybe try by using that service to delete a Publisher object from the catalog?

Muthu S

Thanks @JohnW-Oracle @Gianni Ceresa for the quick reply. While looking more into the catalog items I was trying to delete, like with extension .xdo, their type was returned Folder. So, the removeFolder operatoin, with recursive set to true, did remove the .xdo item from the webcatalog.

The documentation for deleteItem says "The path to the object in the Web Catalog". So, I thought we can use deleteItem in general for all webcatalogs except the folder. I believe everything in this path is the folder /shared/Custom/Financials/Test Workflow Notifications/Budgetary Control/ and the last one is the item that we can remove. As you said, I need to check more into other types and see when deleteItem and removeFodler must be used.

"

Gianni Ceresa

Good spot!

The XDO is one of those catalog objects that while showing as "object" in the UI, is physically a folder containing a number of files (there are a few others being like that). The XDO folder can contains configuration, a picture with the preview of the report, RTF templates etc.

I believe one of the webservice methods tells you if the object you reference is a file or a folder, that could allow you to adapt your code and make it "dynamic" based on the need.