OBIEE can see everything you connect it to. If you connect it to a datasource with real time data, OBIEE will see real time data. OBIEE isn't a database, it doesn't store data locally, therefore it sees and uses what the sources you connect provide. (Of course don't enable cache and expect to see real time data as it…

I'm not 100% what you call the BIP client, I know about BI Publisher Desktop which is a tool mainly to build Publisher reports templates in Office to generate Word documents etc. But it's correct: if you have OBIEE you have a fully working BI Publisher inside it, no need to install anything else to get started. Create a…

BI Publisher is embedded into OBIEE. BI Publisher is a different kind of tool, mainly used for pixel-perfect-reporting. BI Publisher reports can be of various kind, either generated as web pages visible online from inside OBIEE or as generated files (or both).

Double posting is against the rules of the forum. What is the difference between this and https://community.oracle.com/tech/apps-infra/discussion/4478943/how-to-control-rownumber-function-in-obiee-12c#latest ? Your thread is far from being explicit in what you look for. OBIEE generates queries based on models and formulas…

Your process of testing this is flawed. If you look at the help coming with your Admintool in the "Merge Repository Wizard" screen, you see that there are simple diagrams showing the process. And the doc also shows (and says) that in this case the final "production" repository is now becoming like the development…

Damn Christian, at least add a "sarcasm" hint to your post: there are people who are just going to do what you said 🙄 😂😂😂

That config node is gone in 12c, and it would anyway impact the search window which does already work as you want but you don't want to use. All in all, based on everything posted, there is an obvious data quality issue and you can't expect OBIEE to just deal with that and solve all the problems. Sure you can turn your…

The config file has an explicit message next to that flag: "Case sensitivity should be set to match the remote target database". Is your database case insensitive? If it isn't, you can't expect OBIEE to do miracles as it isn't a database.

If you use the "search" windows of OBIEE when selecting the value to filter by, by default OBIEE does a case insensitive search in the values you can then select what you were looking for. I believe you want to add a filter in the criteria as you say you know how to deal with that in a Dashboard, or what else do you mean…

I would change the "can" to a "must": once an hierarchy exists in a business model, all dimensions must have one. You should have a warning if not an error in the consistency check if it isn't the case.

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.