Simple Calculations do not work in BICS (Doc ID 2055030.1)

Last updated on JANUARY 27, 2016

Applies to:

Oracle Business Intelligence Cloud Service - Version to [Release 15]
Information in this document applies to any platform.



Issue Seen : Create a simple Analysis in Answers with  1 Fact and 1 Dim


1.Dim Customer

a.Rid (customer id)
b.Correo1 (email)
c.some more attributes.

2.Fact Metrics
b.# Registros  = count ( rid )
c.# Correo1 =  count ( Correo1 ) – this counts all the non-null values.


Create a new analysis, a simple table with a calculated field showing #Correo1 / #Registros

But the value of #Correo1 / #Registros always shows up as 0.0000


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms