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

Daniel Murray dtmurray3 at gmail.com
Tue Apr 1 12:48:03 EDT 2008


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/20080401/74f8293b/attachment.html 


More information about the Mondrian mailing list