Webi/Bex strange issue

Hi All,

Any help/inputs on this really appreciated.

We have BOBJ 3.1,SP2 -FP 2.5 /BW7x environment and we are facing some strange issues.

1. For the first time when we create the webi query the results are coming fine.

2. Second time same report when we refresh :

i. All the measures are gone (display out of the report)

ii. Columns are swapping (say like , Country = USA, State = CA in first refresh, on second refresh its become Country = CA, State =USA

This is something strange issue we are facing If you guys come across similar situation, can you please advise.

Thanks,

Pats