I don't have any special reference related to OBIEE. It's just a standard proxy setup (so nothing to change on the OBIEE side), you generally take a standard simple config (allowing Nginx to start) and set the paths you want to forward and where (like /analytics => http://your OBIEE:9502/analytics etc.). You can also use…

Running it as root messed up your permissions here and there. Any reason to not just add a simple proxy in front doing the job for you? Even Oracle with cloud by default deploy a proxy (in their case it can also act as loadbalancer if needed), they use Nginx, a super lightweight, simple and powerful webserver which listen…

Tested an iframe in 12.2.1.3.0, after setting the CSP the iframe content load just fine. Your javascript didn't work at all for me but the iframe is there I would highly suggest you give up that javascript code which is about 15 years old and use jQuery instead: it's there by default in OBIEE 12c and it support events a…

Isn't this setting the other way round? It allows OBIEE to be embedded as iframe in other pages, while what I get from the OP is that he wants to display an APEX page inside an iframe in OBIEE. I still didn't have a running environment to just try it and see the messages the browser return.

Mmmhhh ... you did what and what's the issue? I'm not sure how configuring port 80, root.atr (the mandatory binary file at the root of web catalog) and starting services (btw OPMN doesn't exist anymore in 12c) all fit into the same sentence ... For starting your environment you have a simple "start.sh" script which does…

Didn't you say you checked the documentation and configured CSP in OBIPS accordingly to your needs?

"could not get the iframe to work" doesn't say a lot .... So what happen when you do that? What does your browser display? What does the browser tell you?

Why do you want to revert? Put the new (right) password and done. There are also documents in MOS about password changing to make everything "clean".

Hi, The weblogic password is generally saved in an encrypted format in files to allow weblogic to boot without prompting for username / password. So when you change the password you need to update those files as they keep containing the old value otherwise. Have a look at this to see what is that thing:…

Did you open a SR and asked Oracle? I guess I saw some threads where that kind of cases ended up being fixed with MOS giving some "magic keyword" to set in the analysis as variables to influence the way OBIEE generate queries. (I didn't read all the details in the Word files, just looked quickly)

Also consider webservices and javascript methods to get the infos of catalog items, between the various things returned there are a bunch of dates and users referenced (but I wouldn't blindly trust that).

It's the DB features for your physical database in the OBIEE RPD.

Why? Why didn't you used a supported way of doing things? There are 2 ways of customizing OBIEE, none of them require to modify analytics.ear because it's the wrong way of doing things and will conflict with almost any patch, update and upgrade.

The link Joel posted answer the question perfectly. More in general the concept of "integration" is quite vague. OBIEE is a web application, Jet is web too (in the end it's a bunch of JS and CSS), so you can put your Jet code in an OBIEE page but I wouldn't call it integration.

Who is going to pay? Because licensing is the keyword in the end ... Did you look at cloud? In OAC you can get a small instance and it's provided "ready to use", so maybe it's a solution. Then you have Data Visualization Desktop which could be enough.

Hi, I will say it depends on what you expect to get ... When you look for data of the 28 Feb, what values do you expect in the AGO column? 28 Jan or 28 Jan + 29 Jan + 30 Jan + 31 Jan ? I guess the thing is more in the meaning of "AGO", the fact that part of January is missing is technically not wrong if you ask the system…

"tool"? Define tool ... You can setup a VM, a container or install it on a server. As there isn't one ready to use you have to install it yourself, so the "technical" solution doesn't really matter....

What Robert said, if your values are multiplied by 3 it means one (or many) of your joins is multiplying the returned rows. So look at the generated physical query and you will spot which join is wrong and multiplying the rows.

The rule is "first come, first served" Next time I will distract Joel to avoid him to look at threads

Just guessing ... The bar is too small and so the value can't fit inside ... EDIT: Joel was faster