Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
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…
-
@Misan Omatsone , Definitely speak to your account manager: never ever trust a forum for licensing questions, not even an Oracle one. If you will do something thinking it is fine because of a forum, it's still you who will be in trouble with Oracle if you abused the licenses you have. SMTP license has nothing to do here:…
-
I believe the main difference is that d3 id provided as part of the product, while any other library doesn't exist out of the box in the product. Therefore you would need to provide the library itself too and get that deployed, otherwise it will not be found. Didn't look at custom DV plugins for years, can't remember…
-
Thanks to that column "lead_rank", you can use that to do the job. For example something like TOPN("your table"."lead_rank", 1 by "your table"."department") would do the job. You could also use RANK (by department) and then filter on that.
-
Ok, then the Cloud Customer Connect forum should be the place to ask for it. (It's a parallel forum, same platform but independent from this one, therefore your question can't be moved, you will need to post it again in there.)
-
Ok, so you are inside your Fusion application and just doing things in there? In that case you should go to and look at the many categories about HCM and post in the one that seems to be closer to what you are working with (there should be one about reporting for HCM, but I can't access it, therefore no idea what is…
-
Hi @User_N2N8H , What product are you using? Ideally the full name of the product (the tool you are working with, not the tool you try to extract the data from). This is what Sumanth was trying to find out, because if your question is purely about Fusion data, then you are in the wrong forum (we can point you to the right…
-
Hi, What product and version (OAC September 2024, OAS 2023, …) are you having the issue with?
-
The first comment was from an Oracle person (Sumanth maybe?) asking to confirm the products involved. The second comment was from me asking, like the 1st comment, what product were you coming from and moving to, because there were contradictory information just like in this question: "from OAS to OAC" in the title, but…
-
@Suman Dodda-Oracle , Didn't you ask the same exact thing on Friday? If it wasn't you, then ask one of your colleagues (it was worded extremely close if not exactly the same) and check one of the internal channels where it was answered. @SteveF-Oracle
-
Hi @Hendra_innopia , Just to be sure you are reaching the right audience with your question: you are not creating a Publisher report but an analysis based on a Logical SQL query, right? If it's the case, I would move your question to the right category (currently in the Publisher category), because "SQL" is a different…
-
The issue is that your 3 requirements are by far not beginners-friendly: they are advanced configurations (the 1st one probably being the easier as it's mostly done outside OAS). Your 1st requirement sounds like you are in an Enterprise Deployment scenario: there is a doc covering that at Keeping it simple, it's "just" a…
-
Not sure if Catalog Manager will really be able to do much, "my folder" has a very strict (private) security and Catalog Manager in OAS is only "online", meaning that you have the security of the account you use to login applied. Before OAS, that task was easily done in Catalog Manager in "offline" mode, where no security…
-
Ok, moved the question in the OAC & OAS (and OBIEE) category as it's about the RPD and Admin tool. The admin tool doesn't have any embedded feature for backups. But it's just a file, therefore you can setup any backup process you want on that file. If it's an offline RPD, then you could look at some Windows utilities to…