RAND()
OBIEE allows us to generate random numbers using the RAND() function.
This function works in Answers and generates psudeo random numbers in the range between 0 and 1.
This is a presentation services BI server only function and is not pushed back to the database.
All normal arithmetic and number based calculations can be performed on the results of this function.