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

Moved to the FDI SCM category

Hi, Are you using FDI? If yes, which one between ERP, SCM, HCM, CX? Just to know where to move the question. If not, your question being about data of a Fusion application (I guess), you should ask in the forum looking after that application. Publisher is the technical tool where you want to write your query, but doesn't…

In addition to what Sumanth said, it is already being reported and covered in 2 threads here in the forum. The most "active" (including workarounds, comments etc.) is this one: https://community.oracle.com/products/oracleanalytics/discussion/22504/got-the-message-about-tbaddin64-add-in

Hi, Not sure you are asking in the right place. Could you share the name of the product you are using? From where are you linking to those documents? What is the "thing" (portal, application) where you click? Based on your answers the question can be moved to the right category, or we can point you to the right forum if…

Taking a step back, you said that everything you tried gave you the same error. You also talked about SSO, meaning it’s a corporate environment probably. Is it possible that your OAS is in a corporate network with some kind of firewall or other network security in place preventing any connection to the REST APIs you tried?…

(Sorry for the not-fully-complete replies, let's blame 11:30pm :D ) I tried again with a file (the forum add new lines everywhere, I don't have any empty new line in my file): { "name": "Test 002", "description": "Testing...", "baseURL": "https://api.restful-api.dev", "endpoints": { "objects":…

Closing this thread as it's 7 years old. @User_950EF , please post a new question with your requirement and providing the product name and version you are using.