I'm taking a shortcut on Christian's answer and assume you talk about OBIEE Answers (based on some of your previous threads, but if you mention the product & version it would make life easier ...). When exporting there is the "Formatted" type of exports which will return you the content of the view you are exporting, or…

If you look in the official 11.1.1.7 certification matrix you find all the info about 12.1 certification (https://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-ps6-1928219.xls). 12.2 isn't mentioned because it didn't exist at that time, and your 11.1.1.7 is totally out of support and you badly must plan an…

This isn't a feature of the tool. The embedded lightweight LDAP into Weblogic is there mainly for development sandboxes. OBIEE is an enterprise platform and the ideal setup is to link to the enterprise directory service (Active Directory, LDAP or your own solution). OBIEE outsource the task to manage users and their…

The "realm" is linked with HTTP basic authentication, it isn't for a URL: https://stackoverflow.com/questions/12701085/what-is-the-realm-in-basic-authentication

This is what I used:

Any website RSS feed, the first Oracle random one I found: https://asktom.oracle.com/pls/apex/asktom.newest.rss Everything has a port, even if you don't see it: HTTP is by default 80, if you don't see it the default is used. http://google.com is the exact same thing as http://google.com:80 . HTTPS by default is 443.

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.