OBIEE 11g: RAND Function May Not Work as Expected
Last updated on NOVEMBER 29, 2016
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.0 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.
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