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 15.2.4.0.0 to 15.2.4.0.0 [Release 15]
Information in this document applies to any platform.

Symptoms

 

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
a.Rid
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

Cause

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