Can you flag your last post as the correct one? So people will not have to read everything and will directly see the answer (and it will also close the thread which is This question is Not Answered. for now)

Hi, It's a bit more complicated than just check a URL if you really want to check OBIEE. Sure you can load a page like /analytics, but this doesn't mean that the login work for example. So you can simulate a login (posting the form etc. or using nqUser and nqPassword in the url). But here again it just means the login work…

I can have this error when I try to write a CASE WHEN in a physical foreign key join. This is what Christian first said: if it's a "simple" join you must first delete it and create a new one which will be saved as complex join (with the CASE WHEN directly) and not as foreign key join.

You know that if you post directly everything we are not going to try to guess what you maybe try to do?

True: if the join is already saved as physical foreign key join first delete it. The properties window of the join clearly tell you the kind of join:

Yes, open the expression builder and write it there inside (so not directly in the textarea, the "Expression" field, of the join).

I'm curious: this worked but not this Hide Column in Grand Total row ? Which is exactly the same thing but you said it didn't work ... (the only difference is the screenshot taken on 11g instead of 12c Christian used)

Khalid Ibrahim wrote:After restarting services ... So it was working before! Who is managing that server? Who is managing the DB? Who is managing the network? Ask these people who changed what and you will also find out why you can't connect your DB anymore from the BI server.

And what about the "easiest" solution? Get these users in OBIEE. I don't mean the real people, just allow their account to exists. They don't need to be aware of it (so they aren't going to use the tool for real), but if the users exists you can then run the agent as these users and have your filters all applied based on…

Christian already said almost everything So you look for a set operation and not a by row operation. What you wrote just doesn't match, you can't with a simple query do what you asked (try to write the SQL doing what you want and I can bet whatever you want it's a bit more than "user='a' and user='b' and user='c' ".…

You are welcome, and +1 for @Thomas Dodds about the qualified name: I just always believe this one is checked all the time :s If you manage to make it work and got all your answers you can maybe close the thread at some point, for now it's still This question is Not Answered.

Just did a quick test: With FireFox 53.0 (32-bit) I can perfectly login without issues on a 11.1.1.9.0 (Build 150415.1247 64-bit) OBIEE. So ... not sure the exact version of your OBIEE but if it's a .0 then it's not really a Firefox issue (I didn't change or set anything special in my Firefox). Did you try the classic…

@Sandesh AG : did you give up on that one?

Hi Daniele, Does it works fine with another browser? Was it working fine before Firefox 53? (like with 52 or previous release) If you answer yes twice the issue isn't OBIEE but Firefox: no idea what they changed in v53 but something maybe related on how JS act/react and so it's not working as before.

Hi, Congrats on your first RPD editing You said for now you have 2 different schemas in 2 different data source (so I guess 2 different DB object in your RPD each one with a different connection pool). Right now you can already join things together like you normally do in OBIEE: select the few objects, right click >…

Hi, Stop everything (if something is still running) and then delete the file(s) in .../user_projects/domains/<your domain: bi by default>/servers/AdminServer/data/store/default/ (you must have one file named _WLS_ADMINSERVER000000.DAT ). Once deleted restart everything like you normally do (start.sh).

Hi Syed, Delivering an agent to external users is easy and supported without any kind of SA or setup or conditional analysis: simply enter the email addresses as recipients in the agent, done ! But how do you send from a single agent different content to different users which are just email addresses? That's the impossible…

Maahjoor wrote:-SI pdborcl Why are you passing the service instance of your DB to OBIEE? Did you really changed the service instance from SSI to pdborcl? (the screenshot says it's SSI ...). Maahjoor wrote:only one thing which i do to my computer which is resetting the network wifi adapter and restarting my computer So I…

I must be missing the point: 2889517 wrote:The logs are fine. If I start BI Services using one of the oracle scripts, it works fine, WebLogic comes up fine. Why don't you stay with the script then? As you don't say what OBIEE version you use I guess it's the one with the provided ant script, so if you look into the script…

Not exactly sure what you expect as you don't really provide anything useful ... Start looking at log files, everything is logged so into the log file you will probably find something a bit more explicit. PS: this doesn't mean to post here 2000 rows of logs, try to identify the interesting bit and if it isn't explicit…