There is nothing in the product "generating" rows out of nowhere, therefore you need a query to generate those rows for you. If you have your "contract details" in a table, and you have a time dimension in a different table, by joining them together, you can generate the rows you need. Just to give you an idea of what I…

Hi, You should consider to formulate, with words, the business rules you need to apply. Because based on the 3 examples there is a lot of guessing required (like your "GHI" which ends before to start, assuming your dates are written in a consistent way adopting the American standard of MM/DD/YYYY). Having an example is…

Ok, that makes sense, thanks. I'm moving it in the FDI category, this should give you more chances to get a valid answer.

Hi, Welcome to the Oracle Analytics community and forum. As your question is all about database objects, I suspect you aren't using OAC or OAS directly (because they don't come with any data). Are you using FDI? Or OBIA? These are the 2 products that could come with a pre-designed database model loaded with data from a set…

You don't need to find the deployment in WebLogic, and you better don't start going around in there (there are probably 50+ deployments in your bi_server1 managed server, the DV one is one of those, can't remember the name, but you don't need to be there at all). After you installed the product, and after your run the…

Going a step forward, in case you look for that migration-tool.jar, it isn't in the GUI of DV anymore (removed some time ago from there). But read , you can generate it by executing a script in your OAS 2025 installation (once it is fully installed and configured). Just run that script, I got a jar at the end, but no clue…

Are you looking for this migration-tool.jar?

Hi, Welcome to the Oracle Analytics community and forum. You shouldn't look for DV as a WebLogic component. It is by default part of the product and there is no way to not install it, therefore you have DV with your fresh OAS 2025 installation. Just access the product after it is started, and by default the login take you…

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

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 quite explicit). Therefore you will need to provide more context: a product name and version,…

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 , it is a…

Did you open the link posted above to the certified systems? 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…