The logical joins drive the list of options you see or not. Because the joins decide what is the role of the logical table: dimension or fact. Once your dimension has a logical join joining it to a fact table, the content level of the LTS of the dimension only shows the hierarchies of that logical table. If you look at a…

Hi, What does "not working" mean? Do you have an error? Do you have no value? Do you have a number you don't like? What are the formulas you tried already? In case you had numbers back, where did that number came from? Isn't it that the formulas worked as expected but you wanted some other numbers (meaning that you don't…

The certification matrix always give these things. Only OAS works on FMW 12.2.1.4.0, OBIEE 12c (.3 and .4) are on 12.2.1.3.

You are not the only one after this, maybe the other one is just one desk away from you? 😁 https://community.oracle.com/tech/apps-infra/discussion/4477192/how-can-i-display-both-number-and-percentage-data-markers-in-a-bar-graph-in-obiee#latest

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…