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).

+1 Sherry George: @3208479 if you want to convert a string to a date at least you could post the string you talk about ... Your formula seems to find the date of the birthday in the current year (so if you were born the 15 June 1980 your formula would return 15 June 2017). And as Sherry George said, what are you trying to…

Ciao Simone, If your need is to just have that query and nothing else (so forgetting about OBIEE etc.) you can do it as an opaque view in the RPD, drag and drop over the 3 layers and done. But this will be just like the directly DB request: paying an expensive license to do something that SQL Developer, a free tool, would…

user2461087 wrote:None of the users who will be receiving reports are OBIEE user. SA subject area can't help at all ... This appendix describes setting up the SA System subject area to retrieve user information from a database and populate user profile information. Oracle BI Presentation Services delivers alerts from…

Hi Simone, Are you allowed to tell the end-user he is dumb and doesn't understand what he is asking for? Did he give you the SQL you posted or you wrote it to show what he is asking? Because even a 3 years old can easily see that "c.circ_id" <> "a.circ_id" ... Your end-users sounds a lot like this:…

Hi, user2461087 wrote:None of the users who will be receiving reports are OBIEE user. So you send to email addresses directly? There is unique and single way to do that: as many agents (ibot) as you have managers. As many dashboards as you have managers. Each dashboard will need to have the filter hardcoded, and so you…

Are you using the marketing segmentation things in your OBIEE? Do you have dynamic object names (in the physical layer)? And I imagine that if you run a consistency check you don't have any warning or error ... @dileraco : did you still have this as well or solved in a way or another?

Good practice for sure It also depends a lot on your company and who is in charge of what. Often a "one AD group to one application role" mapping is adopted, in such way you give the responsibility to manage that part of the security out to the security team and you simply set restrictions/authorizations on content and…