+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?

Sherry George is 100% right (and said the same days ago). The setting isn't at the section level but it's a 3 levels inheritance: dashboard, page and analysis in the page. Can be set at any one of the levels and underneath levels can override the settings coming from above (so dashboard > page > analysis). We were there 5…

Hi, OBIEE can sort ascending or descending, as you said (and saw). If you want a different sorting you must provide OBIEE with something it can use to sort on (ascending or descending again). So you need a sort column. If that custom sort order is the one you want all the time you can set that column in the RPD: If you…

Hi, Not sure to get what the rule behind your "max month" ... Do you want to get for each quarter the month which has the maximum value of measure (for example "for 2016 Q1 the max sales where in February") or do you want to get the "max" month available in your data? So if your fact table has some data for 14-Jan-2017,…

Yep, much more clear It's not really a common setup to have 2 domains (not that it can't be done, just that >95% of the setups are a single domain). So even more complex to estimate what the impact on memory usage is supposed to be ...

So you can now close the thread I guess ... For now it's still " This question is Not Answered. " and by closing it you will help others with the same / similar needs.

Do you need 2 OBIEE ? So 2 RPD and 2 catalogs running in parallel?