Comments
-
Hi, Welcome to the Oracle Analytics and AI community. When a feature is in limited availability (LA), it usually means access should be enabled instance by instance (just the right region isn't enough). JR shared his email address, that's your way through it: send him an email, provide all the details of your AIDP instance…
-
Hi Tony, For what you describe, snapshots are pointless because you only want to migrate a given report or set of files, and you don't want to bring along the whole instance (snapshots it's mostly all or nothing, you have little to no granularity in it). I believe I remember past discussions here in the forum about…
-
Hi, The comments on objects in the semantic model aren't populated from the physical source you are using. It has never been the case and it isn't expected. Your approach of generating the JSON outside the semantic model and then copy it back in the semantic model is the correct approach if you want to include the comments…
-
Hi, Welcome to the Oracle Analytics and AI community and forum. What do you mean by SQL Server 19c? Oracle Database 19c or Microsoft SQL Server 2019? If it's the first, yes, absolutely, if it's the second, in the certification document I see that up to 2016 it's certified. But the certification file was mostly produced in…
-
Hi, Welcome to the Oracle Analytics and AI community. You are asking about AI Agent Studio: do you mean the one in Fusion products and not related to AIDP? If that's the case, you should visit the forum covering all the Fusion products, including AI Agent Studio, find the best matching category (they do have a lot of them,…
-
By looking at your 2 results, the difference is in what metric you expect to be used to define a Top10 list. I would say that your question is the reason for the different results, because it is extremely vague. You ask a Top10, but don't give a single hint on what measure you want the Top10 to be based on. If you ask such…
-
9514 was the port of the Model Administration tool online connection. The Catalog Manager does need to connect to the public interface of your OAS/OAC. And the usage of analytics-ws instead of analytics is because, connecting to the public front-end of the product, analytics is protected by the lightweight SSO, while…
-
Hi, What you could fairly safely do is generating LSQL queries for your needs. OAC has that in its MCP tools. If you work with OAS, you will need to give your LLM your presentation layer (fairly simple) and the specifications of LSQL (because it isn't SQL). The OAC tool does that, it does let the LLM know the LSQL syntax.…
-
If you use a single fact table and only dimension tables physically connected to it, setting or not setting the content levels doesn't change the query generated. That's why your semantic model was working just fine. If you want the best designed semantic model, then yes: you should define the content levels. It is a…
-
The answer is quite simple: if your analysis/workbook/report need objects coming from different physical databases (in your semantic model), the BI Server will be doing part of the job. The query will be split into pieces to get what is needed from each source, then the BI Server will start behaving like a database.…
-
In DV, limited export to Excel only (tables and pivots). But requires extra configuration: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/enable-users-export-excel.html
-
Hi, Welcome to the Oracle Analytics & AI community and forum. I suspect you are asking in the wrong forum… Agent Explorer is a feature of Oracle Fusion, not part of AIDP. Can you confirm if you are using AIDP or your question is about Fusion? (HCM is a solution of Oracle Fusion) If you aren't using AIDP, you should visit…
-
Hi, Welcome to the Oracle Analytics and AI community and forum. I didn't read the docs about upgrading to the supported FMW version for OBIEE 12c, therefore will skip that part. Just wanted to say: OAS was first released in 2020. One of the key differences with OBIEE was the support for Solaris being dropped fully (there…
-
Are your users having a problem accessing member of the "Phoenix Facilitator Role" application role as well (while also member of another application role granting access) ? (because "no access" is extremely strong, nothing can beat an explicit no access in the catalog)
-
Is this based on Fusion apps data? Because if yes, then you should ask in the forum covering Fusion apps, their data, the reporting and analysis of Fusion apps data: https://community.oracle.com/customerconnect If not based on Fusion apps, what source is supposed to be used for your report? Because Publisher is an agnostic…
-
Hi, You have the answer available: look at the generated query. The product doesn't invent any number, it does run queries. Queries are generated based on models. If you look at the generated query for your analysis, you will see how that 24,826 is calculated. And by looking at that query, you will probably see what is…
-
Can also work, yes (as you did just make sure to not break the XML, but otherwise it's fine). Just keep in mind that runcat works online in OAS, and therefore it is limited to the permissions of the user you used to connect. If you want to run it over the whole catalog, including personal folders and other paths your user…
-
OAS, therefore as you say the catalog is now in the database. First of all: this isn't a supported way of modifying catalog objects (I have to write this first) There is also a checksum that is calculated on the content field and it's stored in a column of that same table (if not wrong, didn't look into it for some time…
-
As you say (and show), the recipients of an agent are defined in the XML of the agent itself. There isn't another way than editing the XML. Depending on your product, you could do it with a script doing the changes you need in the XML across the catalog on disk (outside of the product), or doing it via SQL if your catalog…
-
Are you looking for https://docs.oracle.com/en/cloud/paas/ai-data-platform/aidco/G42324-01/AIDP_Sample_Code.zip ?