Hi, All the catalog is in the database, everything: /shared, /users and /system. All this is in the BIPLATFORM schema. Yes, OPSS is the piece containing the embedded LDAP and the security mappings and is stored in the database too. It is just not in an easily readable format… OPSS is one of the schemas created by the RCU…

In theory there are ways to do that in WebLogic, but it works better when you are deploying your own applications. In the case of OBIEE there is a lot deployed already, therefore it could be challenging to not break everything by trying to do it in WebLogic directly. As others said, you generally do that in a proxy in…

I'm not aware of a category here focused on Taleo as source, and moving this to OTBI will not help much (because it is more related to the Taleo kind of data than just generic OTBI). In a different forum ( ) they said Taleo is covered in CCC: Maybe have a look there as well to see if you find a category related to Taleo…

Hi Clare, Do your HR data comes from some Fusion application? Or do you use Fusion Data Intelligence? (ERP, SCM, HCM, CX?) Because I believe this category (maybe forum) isn't the ideal one for that kind of question, just trying to find out if there is a better category in this forum where to move the question, or if it…

The system settings mentioned by Mostafa are in DV > Console > System Settings. Search for time zone and you find all the configs related to that. Before setting something there, you should be sure about your data, because that setting will change your OAC behavior when dealing with dates and times. And if you have OAC…

Both users aren't active in this forum. This question was imported from another platform. Please post a new question in , post your product name and version and your question with all the details for other people to be able to provide replies.

Hi Helen, Was this meant to be a comment on your idea on that topic? Or is there a question in there that I'm missing? If you didn't mean to post it as question, we can make it "disappear"…

ExtractDateignore the time component and set it to 12:00:00 am (midnight), therefore doesn't really matter what was the time of your dates, and if you add an hours or 2 in there before calling the function… Because your data comes from a database, what data type is it there? (and what database?) Is it possible that it has…

a)The calculation output is still incorrect (screenshot below ) Why? What is your current calculation doing and what are you expecting instead? The product simply execute queries, therefore you can see what it is doing and then correct the behavior based on your expected result. The easiest way to see queries in a workbook…

What is your data source behind that dataset? Is it a database or a file or something else? I imagine you could workaround it in a "dirty" why by first adding some hours (a few more than your time zone, to safely handle daylight saving time changes etc.) to your date and then get the day from it. The time would be totally…

Hi @Babu Dass , You should consider posting a new question, providing all the details of your environments (from what version, to what version), what you observe as issue, what you did so far to debug the problem etc. This thread is a old, abandoned, question that was about a different situation. Thanks.

The change of date is probably a timezone effect: midnight in your timezone (probably GMT+1 or more) translated to UTC means a day earlier at 11pm or earlier (depending on your timezone).

Ok, this is a different need. To get what you are asking, you should modify the join in the RPD to be an outer join. Currently your project numbers are filtered by the presence of a budget because you probably have an inner join between the project table and the budget table. If you want all the projects, including those…

An OBIEE 11g? Somebody should start planning an upgrade ;-) Are you sure that NULLs aren't part of the result? They would just be empty line because you select a single thing that can be null… Keeping it simple: work on your LSQL query inside OBIEE first, build an analysis, get the result you want, when you get it there,…

You should apply FILTER to COUNT, and not COUNT to FILTER : the first parameter in the FILTER function should be a measure: it's either already a measure in your dataset, or it can be your COUNT(Pr Id). Time zones are always a touchy aspect because "everybody" should be speaking the same language (same location) when time…

You are welcome. And maybe somebody in here also know HCM enough to have an answer, we will see :)

Hi Sophia, Because Oracle is quite large, sometime people are sent to the wrong place, not your fault. I don't know much (anything) about Oracle Recruiting Cloud, but just found an Oracle document saying "Oracle Fusion Cloud Recruiting, part of Oracle Fusion Cloud HCM". Therefore the product you are using is part of Fusion…

Hi, Knowing that there are 3 places where charts can be built, what part of the product are using? DV? "classic" analysis? Publisher? And if you also post a product name and version if could also help. Without going into the answer itself, your numbers have a font that is "taller" than the width of your bars: having…

Hi, Your question is about Primavera P6 and not an Oracle Analytics product, you should ask in a forum covering the Primavera product. Have a look at https://support.oracle.com/epmos/faces/DocContentDisplay?id=1080495.1 , it gives links to the forums covering Oracle Primavera. edit: MOS links do not work in here… keeping…

Hi, In your workbook, in the visualization where you need it, you can add a filter on your date (order date or any other date in your dataset). You can set the filter to be "relative time" and then you select the kind of filter. As you can see from the screenshot you can easily make a "last 1 day" and "last 7 days" filter.…