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.
I am creating two tables in a freeform report and overlaying these tables to appear as one to the end user. I can hide the header titles by setting the font and highlight colour to the same as the background colour but it would be better if there was a functionality to disable the header row completely.
My organization needs a practical way to generate a comprehensive report listing all members—including both direct and inherited assignments—of every custom application role within the Oracle Analytics Cloud (OAC) Console’s Roles and Permissions area. Today, the only built‑in method is exporting one role at a time through…
Currently you are able to change the width of a field in a table or pivot table by dragging the border but there is no option to manually fix it to a set value e.g. 100px. Justification: I am creating a report with two tables in freeform and need the field widths to have the same size when I overlay one table on the other.…
Request for an enhancement to Oracle Analytics Cloud (OAC) Classic Analysis Selection Steps on measure suppression for a specific calculated member created through Selection Steps. This idea is opened based on the directions from oracle CEAL team, for more details please find the below service request. SR -…
Hi, We use a lot of Custom App Roles in OAC Console and It would be easier to have an API to manage the members of App Roles.
