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: But, there are WLST commands that allow to work "inside" the permission sets. On you can see that there are many commands available. A permission set is called "entitlement" in 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: 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 defined, you should provide details about your data source structure and the current template you are using. If you are asking about how…

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 , 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 precise about what feature you are interested in, it will be possible to answer more in detail (maybe just saying it…

Hi @User_0GPX5 , You should ask in the forum that cover the Fusion products:

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…

Honestly? I didn't try lately, and therefore I can't affirm what the behaviour will be… https://support.oracle.com/epmos/faces/DocContentDisplay?id=2852874.1 Seems to be not so optimistic, saying it's the GUI and the 100 to 5000 setting and you have to stick to it. I don't have an OAS environment up and running right now…

Hi @Ruma Bhatnagar-Oracle , This is a 8+ years old post, that has been moved across 3 different forum platforms over the years and lost attachments, pictures etc. If you have a question, please post it as a new question in . Keep in mind to provide all the details that somebody now being in your position would need to…