Hi, In OAC March 2025 you have a new feature named "Create and save multiple personalized workbook states". Watch the video below for details on what it is. You can't rename anything in the UI that isn't defined by a user. The word "Workbook" is part of the product, because those are workbooks. It's maybe easier to teach…

When looking at the physical query generated with the CASE WHEN formula, you see that it's a very complex query for what should be very simple. The query start doing the right thing, in a very complicated way, then go into analytical functions for summing over partitions and it finally decide to only take the first row for…

The simplest way to find the best syntax, is to use the UI window to make the expression. It looks like parentheses is what makes the composed condition work: a set of ( ) after USING and there inside you define your expression. But use the UI to build it and you get a valid expression to start with.

Some info to get you started with the OAS catalog in the database. Everything is in the BIPLATFORM database schema. The table css_si_files contains the list of files in the catalog (and other things as well), filter by column namespace = 'content:catalog' to have only catalog objects. You can use full_path to have the…

Hi, Not aggregate meaning that it force the granularity to a detail level and will generate many more rows than expected, or how the screenshot show just empty? If it's just empty, what does the generated query look like? Is your condition correct? (is the year a string and not a number?) The query should point you in the…

Hi, I don't remember having seen official documents on how to handle translations in DV. In "classic" (/analytics) it is fully documented as it's something done for more than 10 years. DV is built in a very different way and with little to no customization in mind. You can't change the top-right Oracle logo and product…

Here is where Oracle said there wasn't a need to document the details of the permission sets… The doc only cover the permission set itself: https://docs.oracle.com/en/middleware/bi/analytics-server/security-oas/grant-or-revoke-permissions-assignments.html But, there are WLST commands that allow to work "inside" the…

This is what I meant with looking into the policies linked with DV Content Author. In OAS you still have full access to the permission sets, and you could look into the resources and permissions linked to the application role via the permission set, and try to find something matching your needs (by name and guessing only:…

Pas de soucis Boris, je comprends bien ce que vous essayez de faire :) What version of OAS are you using? (they should be mostly the same, but just to be sure) I didn't look into the DV policies and various privileges recently, I will look at what is in there once I find an OAS around…

Hi Boris, Do you mean the labels on the left of the 3 on-off switches? That's, sadly, poor UI design… How to fix it? Raise a SR reporting the bug: they need to take all their translation and test their windows with the longest labels. Now it looks like it has been developed with English in mind only. Also, that fake popup…

Hi Christian, welcome to the Oracle Analytics community and forum. What product and version are you working with? Because you are running Catalog Manager on linux, it looks like you are on-premises (OBIEE or OAS). All the OBIEE versions have the catalog on disk, allowing you to do a full text search by using linux commands…

Hi Boris, You tagged OAS, therefore I assume you are using that product. In OAS you have full control on your security model, you can adjust policies as per your requirements, and remove the one you don't want to have, granting it to a new role, let's say "DV Content Author with ML". And use inheritance to make sure that…

You aren't using it, and you are not going to use it in OAS 2025 because it is not available in OAS 2025. At best it will be available in March-April 2026, with OAS 2026. Workbook email scheduler is an OAC-only feature, it was added in the OAC January 2025 and is not part of OAS. As for the server performance issues,…

Hi @MiiKii , Welcome to the Oracle Analytics community and forum. What is "Product Category Fiscal Classification Codes"? It sounds like some data you have in some application, is that the case? What is the product name? If you ask about a Fusion application, you should go to the parallel CCC forum where Fusion products…

Hi @PB2022 , Please no double posting: https://community.oracle.com/products/oracleanalytics/discussion/25200/oracle-fusion-bip-financials-unearned-amount-aging-calculation If you are using FDI, than the new question you posted is better placed than this. If you are asking about how to technically achieve the logic you…

What Brendan said. "Classic" agents have a condition that allow the agent to continue execution or stop it. Just do not abuse the schedule: don't schedule an agent to run every 5 minutes with a condition on the sales drop % if you load your source data only once every hour or once per day. Even if the agent doesn't send…

Hi, How was the clone made? What kind of approach did you use to copy the catalog content from prod to dev?

What do you mean by "scheduling and bursting"? Because if you mean https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/share-visualizations-using-workbook-email-schedules.html , it is not a feature available in OAS 2025 (8.2). Everything that was there in OAS 2024 is still in OAS 2025, so if you can be a bit more…

Hi @User_0GPX5 , You should ask in the forum that cover the Fusion products: https://community.oracle.com/customerconnect

Hi, Welcome to the Oracle Analytics community and forum. The error is an Oracle Database error, there is something in your query, maybe in how the query itself is built that isn't valid. ORA-00904: "SYS_TBL_$1$"."EARNED_VALUE_COST": invalid identifier at OCI call OCIStmtExecute. What you should do is to look at your logs…