Patent ID: 7720789

Claim:
A member unique name (MUN) translation system for translating a dimensional member reference in a first report to a dimensional member reference in a second report, the MUN translation system comprising: a processor; a computer-readable storage medium encoded with instructions for a translation selection module and a collection of MUN transformations; wherein the processor is configured to execute the translation selection module to select a MUN transformation from the collection of MUN transformations, wherein to select the MUN transformation, the processor is configured to receive a source report dimensional member reference and a target report dimensional member reference and select the MUN transformation based upon a source model type associated with the source dimensional member reference and a target model type associated with the target dimensional member reference; wherein the processor is configured to execute the selected MUN transformation to transform a MUN structure of a first data source into a MUN structure of a second data source, and wherein the collection of MUN transformations comprises at least one of: a different source technology OLAP to OLAP transformation for causing the processor to transform a third OLAP MUN to a fourth OLAP MUN, the third OLAP MUN and fourth OLAP MUN being of different source technologies; and a dimensional modeled relational (DMR) to OLAP transformation for causing the processor to transform a DMR MUN to an OLAP MUN.