OBIEE 11g: RAND Function May Not Work as Expected (Doc ID 2203755.1)

Last updated on NOVEMBER 29, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

There may be the case that RAND function does not work as expected.

You get three detail data under specific conditions and you add COUNT("column") to show them in one aggregated column like the next screenshot.

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