OBIEE 11g :- Usage of REPEAT Formula to duplicate the same value

Step 1:- According to My subjet area Drag and drop SUPPLIER NAME, SUPPLIER_ID and agian SUPPLIER NAME.

Step 2:- go to result page and check the out put.


Step 3:- Go to critaria tab and insert “REPEAT” formula - REPEAT(expr, integer). in here replace the column you want to duplicate with expr and replace integer with the frequency.

Step 4:- Result willbe shown as below.