<!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=335300719-02042008><FONT face=Verdana
color=#000080 size=2>I've looked at the threads, and made comments on a couple
of them.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=335300719-02042008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=335300719-02042008><FONT face=Verdana
color=#000080 size=2>RE. the LinkMember feature request. Frankly it's not
particularly high priority. Contributions welcome, of
course.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=335300719-02042008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=335300719-02042008><FONT face=Verdana
color=#000080 size=2>Re. your MDX query... I'm hoping someone in the community
will help you there. I don't have much time to debug
MDX.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=335300719-02042008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=335300719-02042008><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=335300719-02042008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=335300719-02042008><FONT face=Verdana
color=#000080 size=2></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> Wednesday, April 02, 2008 11:48 AM<BR><B>To:</B>
jhyde@pentaho.com; Mondrian developer mailing list<BR><B>Subject:</B> Re:
[Mondrian] Help: Alternative MDX function to LinkMember()<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Thanks Julian for responding.</DIV>
<DIV> </DIV>
<DIV>1) Please refer to the following threads:</DIV>
<DIV><A onclick="return top.js.OpenExtLink(window,event,this)"
href="http://forums.pentaho.org/showthread.php?t=60628"
target=_blank>http://forums.pentaho.org/showthread.php?t=60628</A><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://forums.pentaho.org/showthread.php?t=60624"
target=_blank>http://forums.pentaho.org/showthread.php?t=60624</A><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://forums.pentaho.org/showthread.php?t=60727"
target=_blank>http://forums.pentaho.org/showthread.php?t=60727</A></DIV>
<DIV> </DIV>
<DIV>2) I will log the feature request. Can you advise how long it would take
to get this feature (I imagines its not the only one being worked on...)</DIV>
<DIV> </DIV>
<DIV>3) This is my case:</DIV>
<DIV><SPAN><FONT face=Verdana color=#000080 size=2></FONT></SPAN> </DIV>
<DIV><SPAN>I have an MDX that reads: </SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 10pt"><SPAN lang=EN-US
style="FONT-SIZE: 8pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Arial','sans-serif'">select
NON EMPTY {[Time_Cutoff].[All Time_Cutoff].[2006].[2Q].[Jun],
[Time_Cutoff].[All Time_Cutoff].[2006].[3Q].[Jul], [Time_Cutoff].[All
Time_Cutoff].[2006].[3Q].[Aug], [Time_Cutoff].[All
Time_Cutoff].[2006].[3Q].[Sep], [Time_Cutoff].[All
Time_Cutoff].[2006].[4Q].[Oct], [Time_Cutoff].[All
Time_Cutoff].[2006].[4Q].[Nov], [Time_Cutoff].[All
Time_Cutoff].[2006].[4Q].[Dec], [Time_Cutoff].[All
Time_Cutoff].[2007].[1Q].[Ene], [Time_Cutoff].[All
Time_Cutoff].[2007].[1Q].[Feb]} ON COLUMNS,</SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 10pt"><SPAN lang=EN-US
style="FONT-SIZE: 8pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Arial','sans-serif'"><SPAN>
</SPAN>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], [Time_Issue].[All
Time_Issue].[2006].[3Q].[Sep], [Time_Issue].[All
Time_Issue].[2006].[4Q].[Oct], [Time_Issue].[All
Time_Issue].[2006].[4Q].[Nov], [Time_Issue].[All
Time_Issue].[2006].[4Q].[Dec]} ON ROWS</SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 10pt" align=left><SPAN lang=EN-US
style="FONT-SIZE: 8pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Arial','sans-serif'"></SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Arial','sans-serif'">from
[Cube] </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 8pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Arial','sans-serif'">where
[Measures].[Risk%]</SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 10pt" align=left><SPAN lang=EN-US
style="FONT-SIZE: 8pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Arial','sans-serif'">Note:
(C_Year = TimeCutoff Year, I_Year = TimeIssue Year)</SPAN></P>
<P align=left>
<P
align=left>
C_Year:
2006
2007</P>
<P
align=left>
C_Qtr 2
C_Qtr3
C_Qtr4</P>
<P
align=left> C_Mth6
C_Mth7 C_Mth8
C_Mth9 C_Mth10
C_Mth11
C_Mth12 </P>
<P align=left>I_Year I_Qtr I_Mth </P>
<P align=left>2006
2Q 4
3.60
7.00 <U>10.50</U> 12.60
17.50
22.20 24.90</P>
<P
align=left>
5 0.80
4.20
7.50
<U>10.40</U>
14.30 18.10
21.40</P>
<P
align=left> 6
0.00
0.80
4.60
8.20 <U>12.90</U> 16.30
20.70 </P>
<P
align=left>
3Q
7
0.00 0.60 3.60
7.60 <U>12.40</U>
16.90</P>
<P
align=left>
8
0.00
0.60
5.10 8.90 <U>14.60</U> </P>
<P align=left> </P>
<P align=left>What I need is a generic MDX that would generate the followin
result:</P>
<P
align=left>
</P>
<P
align=left>
Time_Cutoff</P>
<P
align=left> 4thMonth
</P>
<P align=left>I_Year I_Qtr I_Mth </P>
<P align=left>2006
2Q 4
<U>10.50</U> </P>
<P
align=left>
5 <U>10.40</U>
</P>
<P
align=left> 6
<U>12.90</U> </P>
<P
align=left>
3Q
7 <U>12.40</U>
</P>
<P
align=left>
8 <U>14.60</U> </P>
<DIV>Both Time Dimensions have the same structure (ie: Time.All
Time.Year.Qtr.Month); I need to maintain 2 separate Time dimensions.</DIV>
<DIV> </DIV>
<DIV>As noted in the posts, I have tried to build the SET I'm looking for
(translated here and in the above example to: Períodos Cortes=TimeCutoff,
Períodos Cosehcas as TimeIssue) using:</DIV>
<DIV> </DIV>
<DIV>SET [TEST_cast] as 'StrToSet("{[TimeCutoff]\\.[All
TimeCtoff]\\.[CAST([TimeIssue].CurrentMember.Lag(-4).<A
href="http://Parent.Parent.Name">Parent.Parent.Name</A> AS
STRING)]\\.[CAST([TimeIssue].CurrentMember.Lag(-4).Parent.Name AS
STRING)]\\.[CAST([TimeIssue].CurrentMember.Lag(-4).Name AS STRING)]}",
[TimeCutoff])'</DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV>I have placed the above in the MDX builder in Workbench, along with
other Members and no problems... thinking it's working, I try to use
it in the select, I get an error message something along the lines of
"...make sure ... is not a Hierarchy or Dimension..."</DIV>
<DIV> </DIV>
<DIV>I hope you can help... Regards, Daniel Murray<BR><BR> </DIV>
<DIV><SPAN class=gmail_quote>2008/4/2, Julian Hyde <<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:jhyde@pentaho.com"
target=_blank>jhyde@pentaho.com</A>>:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>
<DIV dir=ltr align=left><SPAN><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><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><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><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><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 lang=en-us dir=ltr align=left>
<HR>
<FONT face=Tahoma size=2><B>From:</B> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:mondrian-bounces@pentaho.org"
target=_blank>mondrian-bounces@pentaho.org</A> [mailto:<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:mondrian-bounces@pentaho.org"
target=_blank>mondrian-bounces@pentaho.org</A>] <B>On Behalf Of </B>Daniel
Murray<BR><B>Sent:</B> Tuesday, April 01, 2008 9:48 AM<BR><B>To:</B> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:mondrian@pentaho.org"
target=_blank>mondrian@pentaho.org</A><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></DIV><BR>_______________________________________________<BR>Mondrian
mailing list<BR><A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:Mondrian@pentaho.org"
target=_blank>Mondrian@pentaho.org</A><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://lists.pentaho.org/mailman/listinfo/mondrian"
target=_blank>http://lists.pentaho.org/mailman/listinfo/mondrian</A><BR><BR></BLOCKQUOTE></DIV><BR>
<P></P></BLOCKQUOTE></BODY></HTML>