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…

First: it's a conformed dimension and not a confirmed dimension. Logical level keys doesn't play a role in showing data. It works fine with multiple facts and conformed dimensions in 12c. 875299 wrote:This does not happen always ,it will sometimes show numbers. Do you maybe have cache enabled? How good/bad is the model?…

From the user group? As the concept of group doesn't exist anymore you must use something else. Already in 11.1.1.9 it was advised to move away from groups and use application roles instead. So I imagine you have an application role replacing your group and you can use that one to grant/deny. If this isn't what you look…

OBIEE 12.2.1.2.0 It's still there, didn't move at all But users groups (catalog groups) are deprecated and doesn't exist anymore, so you can grant/deny application roles and users. Also keep in mind this isn't really security, doesn't prevent the users to query the subject area and get data back, it only hide the subject…

Good try but it doesn't manage well the year change. When you are in December in the next 30 days you must get people born in January and for now they are missing (because it will find the birtday of the current year instead of thinking at the next one). It's a common issue when having to deal with that kind of things PS:…

Show them the video tomorrow during the meeting! Can't be worse than how you are now with an impossible requirement

They must have that thing available as a subject area? Because in that case, as said, I'm sorry to be negative but there isn't a solution (as a.circ_id can't be the same column as c.circ_id).