My Oracle Support Banner

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.

Then, you want to show the three detail records separately. Here, COUNT("column") = 3, that is expected.

Once you add RAND(), then you get only one record, and RAND() column is not balanced like next capture.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.