Passing parameters from Transformer Cube to DMR or vice versa

[sureshedara]

Hi All,

I have a requirement to have a report with content from Transformer Cube and DMR in the same report and have the user select a single tree promt and get the results.The challenge is to have a single tree prompt and convert the MUNs from either transformer to DMR or vice versa.
Below is the example of MUNs passed from seperate tree prompts for the transformer and the DMR

Powerplay Cube MUN
[Concentration Reporting Cube V2].[Line of Business].[Line of Business].[Lvl2]->:[PC].[@MEMBER].[LOBUSNONCR], [Concentration Reporting Cube V2].[Line of Business].[Line of Business].[Lvl2]->:[PC].[@MEMBER].[LOBOBEXNC]

DMR MUN
[Dimensional].[Line of Business].[Line of Business Hierarchy].[RC LOB Hierarchy Level02 Name]->[all].[LOBOTHBUS].[LOBOBEXNC], [Dimensional].[Line of Business].[Line of Business Hierarchy].[RC LOB Hierarchy Level02 Name]->[all].[LOBOTHBUS].[LOBUSNONCR]

I was trying to either use the macro functions to convert the MUNs or java script to select the values from the Transformer tree prompt into the DMR tree prompt but with no luck. It would be great of anyone can give any ideas on how to implement this.

Thanks,
Suresh