Analytics Software

Hi ,

I created a OBIEE report in Dev using Answers. When I move the same report to Live, the count of rows was more in Live environment when compared to Dev.

The objects count is same in both Dev and Production.

WheniI verified the log file, I found that the Physical SQL in test has

ROW_NUMBER ()
OVER
(
PARTITION BY c1, c4, c5 order by c1,c4,c5) whereas the physical SQL in Production has
ROW_NUMBER ()
OVER
(
PARTITION BY c1, c4, c5, c8,c9 order by c1,c4,c5,c8,c9)


How this Partiton is done in OBIEE. I have just copied the report from catalog and moved to production.There is no changes in report.

Whether there are any settings to control it? HOw OBIEE does this Row Number() Partiton ? How can get this similiar to Test?

Please help!

Thanks
Johnny