I recently migrated from Cognos 10.2 to R7 and replace all Transformer cubes with cubes created in Dynamic Cube Designer. This is an amazing Data modeling tool.
The functionality/feature that are available in transformer are also available in Dynamic Cube Designer plus there are some really cool features. They run from memory and are 64 bit as oppose to 32 bit cubes created in Transformer.
It would hurt if IBM decides to discontinue support for Dynamic Cube Designer
------------------------------
Vincent Dsouza
------------------------------