My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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


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.


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

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