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!
Read up on the linkMember function and reply if that doesn't work or if you have any questions.
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!