ssas - Get next member that matches criteria mdx -


i attempting return measure 2 periods current member on time dimension need include periods match criteria (is_business_day = true)

i have:

(     [date].[calendar].currentmember.nextmember.nextmember,      [measures].[some measure] ) 

which accurately returns value of measure 2 members in future, need additionally apply filter, can't quite figure out how so.

edit:

my thinking have similar following

(     head(         exists(             [date].[calendar].currentmember.nextmember:[date].[calendar].currentmember.lead(6),             [date].[is business day].&[true]         ),         2     ).item(1),     [measures].[some measure] ) 

as both hierarchies, [date].[calendar] , [date].[is business day] in teh same dimension, can rely on ssas "autoexists" faster exists. hence,

((([date].[calendar].[date].&[20050718].nextmember : null )   *   { [date]..item(0) }  ).item(0)  ,[measures].[some measure] ) 

the : null construct builds set end of date level, i. e. last day contained in attribute.

cross joining [date].[is business day].&[true] automatically restricts set members co-exist in dimension (the magic of autoexists).

and .item(0) extracts first tuple. in case need tuple not of date, .item(0), , measure member, of date , measure in context, apply item(0) after first. extract first member tuple.


Comments

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

git - Initial Commit: "fatal: could not create leading directories of ..." -