I just did a quick test, that source is for RSS or XML feeds. I pointed to a website RSS feed which return "application/rss+xml" as content type and it went well. The data useless as it was a RSS of a blog post, but went through without any issue. That kind of source is for a RSS-like feed, which isn't what your source is.…

What is the content-type header that your web service return? It sounds like your web service isn't a real webservice and isn't returning the right header which probably needs to be "text/xml" or "application/xml". Not only that: is your web service really returning XML? Because in your screenshot I see JSON, not XML ...

Isn't this the same exact thing as https://community.oracle.com/tech/apps-infra/discussion/4476885/wrong-adr-in-a-total#latest ? Double posting is against the rules you accepted when joining the community. You have an open thread, post the addition details there if needed instead of opening another one.

Do you have the dual hierarchy in your time dimension? Calendar and Fiscal? If you do all the normal timestamp functions will work without any issue by just pointing to the right branch of the hierarchy. A "Fiscal year" is a business object, it follows business rules saying when it starts, when it finishes etc. Model it as…

Nothing that cross my mind. Did you check the various documentation "books" on the Oracle site? There are developer guides etc., one maybe cover the various sources a bit more in detail than just naming them.

If I'm not wrong the 2 sources are the 2 main common kinds of web services: one works based on a WSDL (the web service source), the REST one is for REST web services directly. Both speak XML (so if you have a JSON web service it will not really work I believe).

How about generating in a folder which is an external folder in your DB and you have a piece of SQL reading it into a table? It isn't something Publisher will do out of the box, Publisher generates files and write them somewhere, but a PDF into a database table is asking a bit too much...

Using Catalog Manager you can generate reports with the signature of the objects, this give you the type and you can easily do a count on that list. You can do it by the GUI (the full Catalog Manager, not the web one) or command line calling the same runcat.sh/.cmd .

Delete the existing join and create a new one entering your correct expression directly. When you create a physical join as table1.column = table2.column OBIEE does create a "physical foreign key" kind of join. This one is really only column = column and if needed many columns = many columns. Your new join condition is an…

https://community.oracle.com/tech/apps-infra/discussion/comment/16771427#Comment_16771427 You don't .... OBIEE is an analytical and reporting tool, not a data entry tool. There is a limited functionality called "write back", but it isn't meant to be for full data entry. And try to not hijack your own threads: if you have a…

Hi, You could add a ranking by JobName based on end_timestamp descending, and then filter to only keep the ranking = 1.

You have to look at the requirements when using RHEL 7 (check in the certification for the supported versions) and also have a look in the install doc to see if there was a list of system requirements posted for RHEL7 being different than RHEL6. As part of your OS upgrade most packages will just be updated if needed, in…

You are confusing application roles names with their privileges. The name of a role doesn't mean anything, your role can be called "BI God of all the Admins" but not giving you access to anything. Don't look at names but look at privileges and policies assigned to the roles.

For the OS and DB you can look the certification matrix which will give you all the answers (downloading the Excel file and keeping it around will be more helpful than me opening it to check if it's certified). You can install as many Weblogic you want on the same OS, they are independent applications and it's your task to…

Sangeeta Pandey wrote:I hope that OBIEE 12.2.1.3 is compatible with ... WebLogic server: WLS 12.2.1.4? Versions exists for a reason: OBIEE 12.2.1.3 requires and works only on Fusion Middleware 12.2.1.3 which is on Weblogic 12.2.1.3. Only OAS 5.5.0 uses Fusion Middleware 12.2.1.4 with Weblogic 12.2.1.4 (OBIEE 12.2.1.4 is a…

Why do you want to hope when Oracle has multiple sources reporting the proper certification of its products? You have in MOS as a tab, or you have the good old https://www.oracle.com/middleware/technologies/fusion-certification.html .

Look into the official documentation of the product. All that is covered in detail, including the parameter that manage that part. By default Usage Tracking is asynchronous, with a buffer on the BI Server. There are various parameters defining how often UT is inserted into the table, in between these INSERT statements the…

(I need to find something to keep Christian busy long enough while I write way too long replies ...) "My Folder" is always private, even the admin can't see their content by default if you don't destroy your security first. You really need to review how security works in OAS as it isn't in the WLS console: there you just…

Yes, but yours was a guess as there was no info on the version, so was worth highlighting the fact it was still that same document