TL;DR: There is no API that is built to work between different environments. All the APIs only operate in a single environment. This doesn't prevent you from connecting to the 2 environments, read on one side and write the content you did read on the other one. But it's separate read and write calls. Or, if you just want…

The example in does exactly that: it does a LISTAGG on a the names by department. And it does definitely work as I just gave it a try in OAS 7.6: If you add more columns, the LISTAGG will be done by each combination of all the values of all the other attribute columns. That's just standard SQL behaviour.

It does depends on everything else going on in your analysis, in what you model is built on. One of the first results of a random Google search: There are a number of blog posts covering it…

Hi, Your need is to concatenate text, and for that you need to use LISTAGG itself. You call it by using EVALUATE (or EVALUATE_AGGR). That's how it is done because there isn't a "natural" (universal) was to aggregate text.

OAS 6.4 (2022) is out of support being more than 2.5 years old. Parameters are a OAS 7.0 (2023) feature, and they kept evolving with more pieces added over time. If you use DV, it’s very important to have a yearly upgraded planned because all the changes between OAS releases are mostly DV features (packaging 12 months of…

Oh, wait, I maybe misread your initial post. So you mean OAS is available, not EM. In that case discard my previous reply. Ok, in that case, there are situation when EM "lose" connection with the real status of the product. You see it down in EM, but the services are up and running. In your case, having a a cluster with 4…

In DV, the "parameter" is the equivalent of the presentation variables you have in "classic" analyses and dashboard. You can read more about parameters at Because you have different data sets in your 2 canvases, you can't just pin your filter at the workbook level directly, because that would be a column of one of the…

Hi, EM, just like the WebLogic Admin Console, aren't BI services, they are both deployed on the weblogic AdminServer. EM is part of FMW, not of OAS itself.

Hi, Welcome to the forum. The detail of your question maybe got lost somewhere, or maybe you didn't enter it in the first place. Not a big deal… It would help if you could reply with the details, or edit the question to add them. Starting with a product name and version, just in case that plays a role. Then you should…

Hi Johan, Row-wise variables are definitely a thing, but I generally populate them with the result of a query and therefore it's a while since last time I had to set a default value for those. I believe the remember that they are represented as a list of values separated by colons. Instead of ';', try with ':'. It could…

The Catalog CLI is relevant to OAS 2024 just like it is relevant to OAC and OBIEE 12c. The Catalog Manager didn't change much, other than removing the GUI in OAS 2024, the rest is the same as it was for a number of years. The command says it is just sample values, mostly because runcat.cmd is the same on the server and on…

In OAS 7.6, if you use the catalog manager as mentioned above or the webservice available to retrieve those information, keep in mind that security is enforced. You will only be able to retrieve information about objects that the user you are using is allowed to see. You could try to check in DV > Console > Content and…

I don't believe there is such a document, mostly because usage tracking is a basic feature of the product itself. It's a bit like buying a car and asking for a document that says the engine is included in the new car you just bought. If you have any licensing question, you should speak to your account manager: that's the…

Hi Ben, You could add SwissOUC (Switzerland, and no: it isn't "SOUG" that you already have). I'm a co-founder and board member, and therefore definitely also cover Analytics content. We don't have a list of future events for Analytics right now, we are working on a number of opportunities we want to develop with the local…

Hi @Sisanda , First of all: you are asking in the wrong place. Oracle Spatial Studio is not an Oracle Analytics product. It isn't covered in this forum. Google gave me as a forum that could be good for it. And the tool is just telling you that connections you create in there requires some more privileges. Spatial Studio…

Please do not double post!

Hi @Yuvaraj Meganathadu , Can you please post a new question with what you are looking for? This is a 7 years old thread that has been migrated across various forum platforms over the years, and is about Publisher. If your question is about OAC/OAS, ask in If your question is about Publishes, ask in Thank you

Tim, one thing to pay attention at with in-place upgrades: if your domain is not located outside the ORACLE_HOME, do not delete the old ORACLE_HOME once you finished the upgrade. The default location of the domain is, sadly, inside the ORACLE_HOME, therefore if nobody changed that during the install of OAS 6.4, you will be…

Hi @User_JKVJZ , No need to ask in a different forum, you are in the right one, and your question isn't a purely DB one.: the previous reply doesn't apply to you… First, I would challenge the person who decided to implement such a random inefficient policy… As per security recommendation, the policy in our organization is…

@User_27DEY , what is the SQL that can query from the DB? thanks You have been given the default table names that Usage Tracking does use in OBIEE by Arjun above. The instructions to check if Usage Tracking is enable, or to enable it, do not apply to OBIEE 12c because they are for OAS/OAC. For OBIEE 12c you can easily find…