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:

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.

Hi, You can't. It doesn't exist anywhere anymore. It has been removed fully by Oracle 5+ years ago because it was based on a very old version of OBIEE. If you look for something that was meant to be found in SampleApp607, you better post a new question describing what you are trying to do, and a solution will be provided…

Remove the final / in the base URL, and add the / before the relative URL of the endpoint. Actually, in your JSON file the endpoint is a full URL, not just a relative one (the GUI shows the relative one), therefore you maybe just need to remove the / in the base URL. This is for the test API (I tested with a file 25…

@Dhaval Parikh Stantec , I don't have any ServiceNow source available to test it. Did you customize the template you downloaded? I would make sure it really does contains the right info, the right URL, no random comments or example URLs. Also, authentication could be a challenge (I don't know when that template was…

Long story short: import a file with your REST connection details and it works fine (the info from the file will be filled in the various fields and the "Save" button is clickable).

Just a random guess: maybe try with a JSON file defining the endpoints: (If you need more examples you can find some at ) Maybe that connection page expect mostly a JSON file with the endpoint configurations than entering them manually.