Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
No worries, in case of doubts it's always better to post :D But asking in the other forum will probably get you a better answer, and faster, because many more people will know Fusion HCM and its data objects.
-
Is this about FAW or directly a Fusion product? If it's just Fusion, then you should ask in the forum looking after Fusion, because your question is about data and not a technical feature of the Publisher product. Fusion is covered in a parallel forum (lot of categories there, look for the best one): If it's about FAW, if…
-
Are you asking about a Fusion product? If it's for a cloud Fusion product, you should ask in the forum looking after that product because you are asking about data and not about Publisher as a tool. Fusion is covered in , there are many categories, find the best match for your question. If you aren't asking about a Fusion…
-
The odd thing is the query that is running should run once a year or so but it is running daily and we cannot figure out why. It is so odd!! What are you trying to fix here? Are you trying to find what is executing that query to disable it, or are you trying to make your OAS an exact copy of your OBIEE, with all the agents…
-
If not wrong the upgrade from OBIEE 12c to OAS wasn't enabling agents in OAS. The agents are copied and are in OAS, but they are all disabled. In the BIPLATFORM schema created by the RCU you should have the S_NQ_JOB table and a few other related tables where you can see the enabled agents and the logs (if they are running…
-
Hi, You are maybe over-reading versions (and Oracle changed the way to name their product a few times, confusing things). OAS 6.4 is not version "20", it's the 2022 release. OAS 7.6 is not version "24", it's the 2024 release. Oracle announced some years ago they would name OAS after the year, because it is a yearly…
-
Hi, The content of your question apparently got lost somehow… Could you post it again? Remember that the more time you invest in writing a detailed question, the more chances you get to have a reply…
-
If you know the maximum level of your hierarchy, in the dataflow you will need to build a "bad looking", but technically valid, dataflow starting with "manager", "employee" from the dataset itself. Then union all to the same dataset joined to itself with a condition d1.employee = d2.manager and retrieving d1.manager and…
-
https://support.oracle.com/epmos/faces/DocContentDisplay?id=2722590.1 For Oracle Analytics Cloud (OAC): This quota cannot be changed and is managed by Oracle. Generally speaking, it is a rare use-case that these limits would need to be changed. If they do, then it would be an Ideas Lab Request (enhancement). If your…
-
As said earlier already, you can run a python script in OAC if you want. It just is done differently than loading and executing the script directly. But you can also do the work directly in a dataflow if the hierarchy you need to "resolve" has a known maximum depth, or you can push the job back to a database using a piece…
-
I would say to do what Christian suggested before already: raise an SR. Mostly when something references a .cpp file, that's a direct SR.
-
Glad it is working. The sorting column is a very useful thing, mostly for date columns as you just did. It is also has been requested as a feature in DV datasets, hopefully it will come at some point…
-
First, you can't upload a python script in OAC, the only option would be to deploy your code in a different cloud service (can't remember the name now, functions or whatever it is named) and call it from a data flow. What you look for would be "easy" with a parent-child hierarchy, but you are working with datasets only,…
-
I would call it normal, and expected. In DV they kind of merged into a single object (workbook) what was before split into various pieces (dashboard, dashboard pages, prompts, analyses etc.). And each piece before was independent and could link any source it wanted. Each element still has it's own life and execute its own…
-
I would say that you will use the SQLAuthenticator to assign your users to groups ( ), all in the database (that's where you will manage who is part of what group), and then you just map groups to application roles (if you look at the sample database objects in the doc, you see it has users and groups and it handles all…
-
Hi, What product are you asking about? Publisher just execute queries, but it sounds like you are asking about a different product providing the data.
-
Hi, The hierarchy and the keys aren't involved in what you wanted (sorting month by number and not by name A-Z). Those were things I listed to justify why you didn't see all the "shortcuts" on your date field when it comes from a semantic model vs a dataset. To do what you look for, you should just set a "sort by" column…
-
Hi, just a random guess based on the process you described and the error in your log file. Can't you install the binaries in a new folder? You are renaming the folder with the old binaries, which is the same as just deleting everything before to even start the ugrade. All that just because you want to reuse the same folder…
-
It should be named users, not concurrent users.
-
In OAS you can count them also in the database where they are stored. The catalog and the other DV objects are referenced in the tables in the BIPLATFORM schema created by the RCU during install. Of course in OAC you can't do that because you don't have that access, but an export of the BAR would give you all the content…