Update report based on transformer cube

[wyconian]

Hey guys

I've got a report based on a transformer cube.  I need to repoint the report to a different cube which has a different structure and then remap some of the items in the report based on new dimensions in the new cube.

Does anyone have a nice way of doing that?  The best solution I've come up with so far is to hack the report xml to make the changes, it seems that it's not possible to remap an item in a crosstab report from a cube directly in report studio.  Hacking the xml is OK but I'm sure there must be a better way of doing it.

As always thanks for your help

(for once it's actually hot and sunny in the UK)