<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6001.18000" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=503054418-01042008><FONT face=Verdana
color=#000080 size=2>Sorry, I can't think of an alternative if you've tried
StrToMember already. We should really implement LinkMember. Can you log a
feature request at SF.net please?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=503054418-01042008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=503054418-01042008><FONT face=Verdana
color=#000080 size=2>Also, can you send a link to your posts re. StrToSet and
StrToMember? I don't remember seeing them.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=503054418-01042008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=503054418-01042008><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Daniel
Murray<BR><B>Sent:</B> Tuesday, April 01, 2008 9:48 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] Help: Alternative MDX
function to LinkMember()<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Please advise what is a valid function in Mondrian instead of using
"LinkMember"?<BR> </DIV>
<DIV>In MSSQL Anaysis I can use:</DIV>
<DIV> </DIV>
<DIV align=left>Member [Measures].[Risk 4thMonth]
as<BR>([Measures].[Risk%],<BR><B><FONT
color=darkorange>LinkMember</FONT></B>(ParallelPeriod([Time_Issue].[Time_Issue]
.[Month],<BR>-4,
[Time_Issue].[Time_Issue].CurrentMember),<BR>[Time_Cutoff].[Time_Cutoff]))<BR>select<BR>{[Measures].[Risk
4thMonth]} ON COLUMNS,<BR>NON EMPTY {[Time_Issue].[All
Time_Issue].[2006].[2Q].[Jun], [Time_Issue].[All
Time_Issue].[2006].[3Q].[Jul], [Time_Issue].[All
Time_Issue].[2006].[3Q].[Aug],...</DIV>
<DIV><BR>This is an alternative route to previous questions posted on the
Mondrian forum concerning problems with StrToSet and SetToStr.<BR><BR>IŽd
appeciate anyone's help... Thanks, DMurray3</DIV></BLOCKQUOTE></BODY></HTML>