Oracle Communities

Oracle Analytics and AI

Child Item

Home
Oracle Analytics and AI
Oracle Analytics and AI Labs
Oracle Analytics Idea Lab

Provision to change data type of Calculated Columns

It was noticed that in some scenarios, calculated columns created with 2 measures resulted in an attribute column. No provision was found to be able to convert this to a Measure to be used in the analysis. It would greatly help to have this capability added, to bridge the gap.

Find more posts tagged with

OAC

OAS

Needs Votes

Calculated Column

Datatype Conversion

Status: Needs Votes

Comments

Benoît Vedrines

+1. Truly needed feature.

Avinash Krishnaram-Oracle

Forcing the calc to treat as measure might help. Eg: sum(0) + <my calc>. Using a aggregate function wrapping for the calc will treat it as a measure in most cases.

Ambili

@Avinash Krishnaram-Oracle Thanks for sharing this work around, Avinash. Until we have the capability added, this sure can help in the applicable scenarios.