October 13, 2003 at 9:38 am
It appears I'm not quite understanding how the LINKMEMBER function works.
I have two Time dimensions, Time.Service and Time.Paid . Both dimensions are structured the same regarding levels: ALL, Year, Qtr, Month (month is formatted as "yearmo" , example: 200305 = 2003 May.)
My goal is to use the LINKMEMBER function to get the corresponding Time.Paid for any given Time.Service member that is selected.
Below is the function that is not working:
(LinkMember([TIME].[SERVICE].CURRENTMEMBER,[TIME].[PAID])).UNIQUENAME
Unfortunately, the results are not correct. If Time.Service.currentmember is May 2003, the function is returning May 1997 (note: 1997 is the first year listed in the Time.Paid dimension). Why doesn't the function return May 2003?
Here's are the uniquenames:
Time.Service = [TIME].[SV_YEAR_MO_QTR].[YEAR].&[2003].&[2].&[5]
... but Time.Paid uniquename isn't right:
Time.Paid = [TIME].[PAID_YEAR_MO_QTR].[YEAR].&[1997].&[2].&[5]
Can someone instruct me on what I need to "feed" the LINKMEMBER function so that the time frames are the same?
Thanks in advance!
October 13, 2003 at 12:21 pm
Never mind this post. I discovered that the DBA misdefined the unique member ID for one of the time dimensions to just 'month' -- consequently, the linkmember function only linked on month.
Problem solved.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply