RandBetween Function in Cognos

[maheshmogula]

Hi,

I need how to use RandBetween Function in Cognos...I am designing bubble chart on the column(Range(measure))which has values for eg:8.This column has only value 8 for all combination of X and Y Axis.By this the bubbles are getting on the same spot but I want this bubble to be split.In Excel we used RandBetween Function in order to split bubble it worked fine in excel  but we need in cognos so can any one say how to use RandBetween Function in Cognos Pls


Regards,

Mahesh