standard reports available in the menu Others-Financial Reporting Center OAC and OAS comes with no content, therefore I don't know what menu is and what kind of object is there. Is that maybe in a Fusion app?

Joan, You don't really need to redo an install of OAS 2025… Every time you import the BAR you can override almost everything, therefore it's a bit like having a new install all the time. And I don't see why users should exist to be able to import the catalog: when a user leave the company, the personal folder is still in…

Hi, You don't see 2 decimals but you see … no decimals at all? What is the data type of those numeric fields? Are they maybe integers? Can you try to edit the formula of one of those adding a * 1.0 to see if decimals appears when forcing the number to a float?

What Gayathri said: the logs in <domain>/bilogs/metadata/importbar... are extremely (almost too much) detailed and do contain all the details pointing at what went wrong in the process (it can really be a long log, read it carefully to avoid false-errors that aren't the real root cause but a consequence of it). Based on…

If you mean the "Data Replication" option Gayathri mentioned, it is this: It doesn't give you access to physical tables, it doesn't replicate physical tables, it does export PVOs to ADW, and from there you can do whatever you want with those database tables. The details about the PVOs (what means what, what is where etc.)…

Hi, Are you using FDI? If not, where does the subject areas come from (who did build the semantic model)?

Hi, That's how the tool work. The not formatted export (CSV), takes the result of the criteria as it is. The formatted export goes through a number of steps and that's what make it slower. If you don't have any error and the file is exported correctly, not sure you can really do much: that's how the tool work. If times…

@Benjamin Arnulf-Oracle can you close this idea based on the above interaction? Mandeep, ideas involve a workflow that has been defined on the Oracle side, and I prefer to not interfere with it (while I wouldn't mind closing a thread in the other categories). Ben will know how to best handle this :)

Hi Olga, Could you please share if by "report" you mean a Publisher report, a "classic" analysis or dashboard page or a DV workbook? Thanks :)

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…