Welcome to the Oracle Analytics Community

Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Gianni Ceresa Mod

Comments

  • The SOAP API is in the product for 15+ years, I don't see why it would go away any day soon (it doesn't evolve much, but it's still there anyway). The REST API is newer, a lot newer, and being publicly documented for usage only for some years now. It's supposed to be the new API for the product, mostly because REST is a…
  • To be fair I never tried to call it with Postman, I usually was calling it from applications/scripts I was writing, either in Java or Python. It's definitely a more "annoying" kind of webservice compared to REST, because it is less easy to call.
  • Still not sure what product you are using, so let's assume it is maybe OAS… It looks like you are abusing your BI Server to work on a lot of data, something it isn't really good at because it isn't a database. Your query is requiring more disk space than what it can use as temporary files. There are a number of parameters…
  • Are you limited to a REST api call? Or you could also call a SOAP api? The WSDL still expose the "good old" WebCatalogService, which should definitely give you everything in your catalog, whatever type of object they are (the REST api has this "strange" behaviour that without filter it returns the types supported, and you…
  • Due to our organization's security policies, sharing DVA might pose security concerns. When security, privacy, is an issue (and you are right in not upload a DVA that could contains a lot more than just 3 radio buttons on this public forum), you can raise a SR. SRs are managed on a secure platform that is only accessible…
  • @FrazerP , all the replies above talking about the workbook state menu do not apply to you. You are using a workbook ("dashboard" usually refers to the "classic" dashboard object) in OAS 2024. The workbook state menu was added to OAC (cloud) in the March 2025 release. OAS 2025 (the one you could update to from your OAS…
  • Hi, Welcome to the Oracle Analytics community. Do you mind providing more details? What is the product (and version) you are using? What is the url of the API you are calling? How are you doing it? Thanks
  • https://community.oracle.com/products/oracleanalytics/discussion/comment/68459#Comment_68459 Hi, As you can imagine from the message you see on screen, it's an extremely generic message that doesn't really say anything (the BI Server error codes aren't as precise as Oracle Database error codes for example, that are often…
  • Hi Tim, What Oracle product are you asking about? Is that "Constrained Plan" supposed to be the product name? Google seems to suggest that constrained plan is something part of Supply Chain and Manufacturing cloud application. It definitely isn't an Oracle Analytics product (this forum). You should have a look at…
  • Did you open the link posted above to the certified systems? https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-systems.html And OL7/RHEL7 aren't EOL now?
  • Hi, You maybe wanted to ask that in an internal Oracle Slack channel? Because OAC is a black box publicly, therefore nobody can see or touch anything in folders. And if you mean inside the BAR, it's also a topic that is usually not covered publicly…
  • There isn't an info on what part of the product is your question about. You can model this with an outer join reusing the same object to bypass the number of parameters limits. But if you are just working with a file-based dataset in DV, then the only thing crossing my mind is a new dataset based on a LSQL doing the logic…
  • Hi @User_65672 , Welcome to the Oracle Analytics community and forum. You can't export a "refreshable report via SmartView" from OAC. SmartView should be seen as a different "interface" to query data accessible in OAC. But from SmartView you should be able, if I'm not wrong, to point to an existing object in OAC (in my…
  • Hi @User_QXPKC , Welcome to the Oracle Analytics community and forum. As suggested by @GayathriAnand-Oracle , it will be better if you post a new question, expressing your requirement, and also what product, and part of the product are you trying to achieve that. Closing this thread as it was migrated across a number of…
  • Installations are independent and all require their unique components (like the RCU schemas being unique for each environment). The good practise for setting up multiple environments (DEV, TEST, QA, PROD etc.) is by using response files and having a scripted installation. That way you are 100% sure that each environment is…
  • If I understand you correctly you want to enable full SSL, also between internal components? It's a while I didn't run that, lately I stick to external SSL only, leaving the internal communication between components untouched.
  • Hi, Welcome to the Oracle Analytics community and forum. BICC is not an Oracle Analytics product, it is part of Fusion. Therefore it is covered in a parallel, but independent, forum: https://community.oracle.com/customerconnect If you go there you will see there are many categories for the various Fusion products, and…
  • If NodeManager doesn't start, you better try to fix that one first, because it means there are issues with your SSL config. Sure you should be able to start things without NodeManager, but you are exposed to even more issues all around. Did you configure nodemanager.properties correctly? Maybe worth trying both Windows and…
  • Ok, so you are on OBIEE 12.2.1.4 (it's a quite old version now, OAS came after that and we are now at the 5th edition of OAS: any particular reason for installing OBIEE instead of OAS?). The support document referenced should still apply. Windows or Linux shouldn't have an impact, also because SSL is enabled at the…
  • Hi, For the database, to be able to install OAS you must upgrade your database. There are 2 aspects to check in the certification for the database: the data source (linked above) is one thing, but most importantly you need to have a certified database for the repository creation utility (RCU). I also believe Oracle…