Report migration - lose custom sorts and variables wrong

[LouLu]

I have 2 problems arising following migration of reports.

I have created reports against a development universe and applied;
1. Custom sorts to variable
2. Created a local variable that is the result of a complex calculation of two of the variables from the universe

I have then had to move the reports to the production environment which has an exact copy of the Universe - just a different name. I have updated the data provider on the report to point to this new Universe.

On refershing the report against the new universe:
The custom sort does not apply and the values come back in alphanumeric order AND the local variable I created is not bringing back the correct value - although it does bring back a value. If I rewrite the equation behind the variable to EXACTLY the same as it was and click save then it works correctly.

Please provide any help on this if possible - this applies to almost 100 reports created in development env.

Thanks

 

[legend8]

LouLu,
Did you use the copy of universe in development and Import to production? Just migrate the report to production
without the universe will create 'obsolete objects'. You need to migrate the universe as well.
Hope it helps

Legend8