We have several database columns that are saved in UPPERCASE. End users would prefer to see the data in proper case on reports and dashboards. Please add the INITCAP function to the String functions available in OAC.
@MGibbs_2023 — if this were an option in the dataset editor — is that sufficient?
@Luis E. Rivas -Oracle This seems useful.
@MGibbs_2023 I agree adding Initcap would be a useful addition for case handling. In the meantime, Sentence case may be a good workaround for now, it will uppercase the first word in the text and lowercase all others.
If your data is in Oracle DB you can do:evaluate('Initcap(%1)',Employee."First Name")
@Martin_Gibbs_Mayo Please could you comment if the above solution is helping. I will close this request.
@Benjamin Arnulf-Oracle and @Gabby Rubin-Oracle , while the EVALUATE workaround works, but it comes with a SQL Injection Risk and hence EVALUATE is not permitted by a lot of customers. Having a native INITCAP function would make this a clean approach rather than writiing complicated Substrings and Upper/lower concatenations.
Does Oracle have any plans to introduce LLM-based AI features in a future release of Oracle Analytics Server (OAS) on-Premises? In particular, is there a roadmap for bringing capabilities such as the Oracle Analytics AI Assistant or an LLM-powered conversational chatbot, currently available in Oracle Analytics Cloud, to…
Summary of the Enhancement We request two key enhancements to the native Waterfall visualization in OAC Workbooks to support standard financial bridge reporting: Attribute-Driven Category Axis: Allow standard categorical attributes (with custom sorting) directly on the X-axis, removing the current dependency on Date/Time…
Currently in OAC, although we can create application roles in the OCI application (e.g Service Administrator), there is no way to programmatically create and configure custom application roles in OAC itself. This has to be done via the console system settings manually in OAC. We are running a large scale OAS > OAC…
Currently, in Oracle Analytics Cloud (OAC), there is a 250GB storage limit for datasets, but there are no practical management features to operate within this limit. This makes day‑to‑day operations very inconvenient.I would like to request the following enhancements for dataset storage management: Configurable storage…
I'm not very technical so if this is a non-starter or there's a solid workaround that already exists, please advise. We have users that query SQL data sources directly in other tools, but then would like to bring that query as a dataset to OAS. Ideally they could create the view in the database and reference that object…
