@User_FWBDT , As a quick fix I would say you can just comment out the call to the logoff at the end of your script: the open session will timeout and be closed anyway. I didn't use the webservice in OAS 7.6 (2024), but based on Mike's comment above, I see a connection. The error seems to be saying that you can't call the…

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 https://jethinabraham.com/2017/08/29/string-aggregation-in-obiee/ 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…

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: https://datacadamia.com/dat/obiee/obis/logical_sql/evaluate https://jethinabraham.com/2017/08/29/string-aggregation-in-obiee/ 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 https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/what-are-parameters.html Because you have different data sets in your 2 canvases, you can't just pin your…

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 https://community.oracle.com/mosc/categories/spatial as a forum that could be good for it. And the tool is just telling you that connections you create in…

Please do not double post! https://community.oracle.com/products/oracleanalytics/discussion/23400/gettingerror-ora-00904-cpi-clearing-ccid-invalid-identifier-while-running-us-1099-paymentsreport

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…

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…