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…

Hi, Did you check the certification matrix? You don't say which version of OBIA you have (I was betting on 7.9.6.4 as you have Informatica), so can't really check for you, but if you look at Oracle Fusion Middleware Supported System Configurations with your OBIA version you find all the details. If you look at the "Current…

Take all the previous answers, put them together and you get your solution What you ask can be done in few ways, some being better than others. If you can filter at the AD level (so pointing OBIEE to a subset of your AD only, a sub-branch or something, or add an extra condition based on membership of the users to a group…

No luck ... Also because it's a kind of really annoying issue as you can't really find out a pattern Would be nice if you can come back with an update once you heard something (I hope) from Oracle. In case you have time/resources you can maybe also try a 12.2.1.1.0 ? (as you are now on 12.2.1.2.0)

3410125 wrote:This will generate digits in that column. Nope, this will generate varchars in that column, so if the OP needs to sort over more than 10 elements the sorting will be '1', '10', '11', ..., '2', '3', etc. So the CASE WHEN was one of the options suggested at the beginning, but must be done correctly Also an…

Hi, Did you check the guide about embedding OBIEE in other apps? Integrating Oracle BI Presentation Services into Corporate Environments Using HTTP and JavaScript user9159846 wrote:Please tell me that need tweaking, as there is a bug. BI EE report is not displayed in the iframe.... What "bug"? What happen to your iframe?…

12c comes with jQuery loaded and heavily used out of the box. window.onload is a really really old way to try to make things, have a look at https://api.jquery.com/ready/ and use the jQuery event handler, it will always work (as long as the page is fine). It also depends on what your code try to change, because if you try…

What version is your OBIEE?