[Mondrian] Help: Alternative MDX function to LinkMember()

Julian Hyde jhyde at pentaho.com
Wed Apr 2 11:59:23 EDT 2008


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?
 
Also, can you send a link to your posts re. StrToSet and StrToMember? I
don't remember seeing them.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Daniel Murray
Sent: Tuesday, April 01, 2008 9:48 AM
To: mondrian at pentaho.org
Subject: [Mondrian] Help: Alternative MDX function to LinkMember()


Please advise what is a valid function in Mondrian instead of using
"LinkMember"?
 
In MSSQL Anaysis I can use:
 
Member [Measures].[Risk 4thMonth] as
([Measures].[Risk%],
LinkMember(ParallelPeriod([Time_Issue].[Time_Issue] .[Month],
-4, [Time_Issue].[Time_Issue].CurrentMember),
[Time_Cutoff].[Time_Cutoff]))
select
{[Measures].[Risk 4thMonth]} ON COLUMNS,
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],...

This is an alternative route to previous questions posted on the Mondrian
forum concerning problems with StrToSet and SetToStr.

I´d appeciate anyone's help... Thanks, DMurray3

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080402/04155c5c/attachment.html 


More information about the Mondrian mailing list