Oracle Analytics and AI

Marcelo Finkielsztein

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Confidential

Description (Required):

implement InitCap function in Logical SQL. Use the Oracle specification and syntax for further reference

Use Case and Business Need (Required):

Users request to see certain names and descriptions using "Init Cap" mixed case.

e.g.: column for country names. The physical table contains

"UNITED STATES OF AMERICA", "CANADA", "UNITED ARAB EMIRATES"

Users request to see: "United States Of America", "Canada", "United Arab Emirates" on their analyses.

We would like to be able to implement this at the RPD level, in the Business Model/Logical level, without involving changes to the physical layer.

It would be handy to have this also in DV, when we create datasets.

Enhancement Request / Service Request:

N/A

Pravin Janardanam-Oracle

@Marcelo Finkielsztein You can accomplish the same using an EVALUATE function with a database Function.

Syntax 

EVALUATE('db_function(%1...%N)' [AS data_type] [, column1, columnN])

Where:

db_function is any valid database function understood by the underlying data source.

Example for Oracle Database

evaluate('Initcap(%1)',Employee."Employee First Name")