Working with different dimensions

[godawgs85]

What is the easiest way to parse a MUN in order to reflect a separate data item.  For example, I have a member called Current Day whose MUN is as follows:

[Apple STR Weekly Cube].[All Dates].[Current Day].[Day]->:[PC].[@MEMBER].[20130615]

Obviously the day will change depending on when I run the query/report.

I'm attempting to create a data item which mirrors the date of Current Day, but pulls from a separate dimension with and MUN, such as:

[Apple STR Weekly Cube].[All Dates].[All Dates].[Day]->:[PC].[@MEMBER].[20130615]

I have used a substitute function in the past, however it's always been referring to a prompted value.  In this case, I have no prompt value but simply a non prompted MUN I'm trying to manipulate.

What's the best way or expression to do this?

Thanks in advance!

[CognosPaul]

Read up on the linkMember function and reply if that doesn't work or if you have any questions.

[godawgs85]

Thanks for the direction.  I was able to get it to work.  I used the following formula:

linkMember (lastChild([Current Day]),[Apple STR Weekly Cube].[All Dates].[All Dates].[Day])

Thanks again!