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.
We want to increase the rest api limit for this payload to incease from current 25 limit to 100. we are calling this api through RF Smart and due to limitation for paging size, the packing units more than 25 does not show up. Can you please increase the limit atleast to 100.…
We have observed a potential issue with dataset refresh schedules when changing the Data Access mode. When a dataset is configured with Automatic Caching, a reload schedule can be defined to refresh the data at specified intervals. However, if the Data Access setting is subsequently changed from Automatic Caching to Live,…
Would like for the old classic BIP bursting feature to be fully Agent aware so that end users no longer need to be concerned with scheduling via the classic console or building out as many BIP reports just to support this one thing.
We have various data sources in Microsoft Fabric and need the ability to build reports in Oracle Analytics Cloud that connect to data sources in Microsoft Fabric. This is an unavoidable reality in today's complex data ecosystems. Microsoft Fabric requires authentication via Microsoft Entra. We opened an SR and Oracle told…
With the OAC Visualization AI Skill, users can potentially extend existing custom visualizations and address limitations encountered in real-world use cases. As an example, we used the AI Skill to enhance the OracleVectorMapsH3 visualization from approximately 10,000 data points to a version supporting up to 50,000 data…
