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.

Ah, that :D Well, that screen is … buggy. I had the same, and at one point my endpoint was showing twice. I tried to delete the second endpoint a few times, didn't work, so I started clicking everywhere in the page to see if my browser was frozen, and I even clicked on the "back" arrow (top-right in the popup). At one…

So, for the REST API with URL = I did set a base URL of , then I added a endpoint named "objects" with a relative URL of /objects .

I just created a test connection in a OAS 7.6 (aka 2024) and it does work. I googled for a random free REST API for testing, found , used as endpoint and it does just work. You could maybe share what you did, how, what you get back as message etc.

What Steve said is important: changing things in the scheduler table also require, in an ideal situation, to update the agent in the catalog to match the config of the scheduler table. It isn't ideal, but should break (this is actually what OAS uses to detect that you have agents that should be enabled but aren't currently…

An example of what I mean… If I want to display only 1 product by LOB, and I want the product with the higher Product Number. TOPN("P0 Product Number", 1 by "P3 LOB") displays 1 because it does display the ranking of the row, because you only return 1 row per department, it will always be 1. Doesn't matter much in the end,…

In my example I posted an example of TOPN using by, by using the "by" piece, you change the level on which the function is executed. And TOPN doesn't really care what is the higher number, it just rank by that and filter the number of rows based on your parameter.

@User_F52SO , Welcome to the forum. In a public forum (like this one), you should change the display name of your profile to identify as an Oracle employee (I believe it's one of the rules for employees). Keeping it simple FDI (named FAW before) is a set of products and pre-packaged content, while OAC is only an empty…