Hi Team,
As per OAC FAQ document there is no possibility to change EPM Column Datatype (Oracle Essbase Data Source) on OAC Workbook level.
Customer is looking for this feature on OAC. Please let us know the roadmap for this feature.
Ref - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acski/index.html#GUID-4B28CFD0-1068-4329-AEC1-1F44BA744A62
Section - Known Issues with Oracle Essbase Database Connections and Data Sources
Statement - When you import an Oracle Essbase data source, you can’t prepare the data, and you can’t edit the data after import. For example, you can't change a column’s data type or aggregation.
Regards,
Prabhuram