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

Post a Comment

Popular posts from this blog

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

-
i trying make initial commit git repository on github unity project. followed along this guide am. note: reason or another, couldn't set unity's asset serialization mode force text, settled on mixed (which believe should work). when call git clone --bare . , error. note not creator of repository , contributor (though making initial commit). here's in terminal (i'm using git bash): welcome git (version 1.8.4-preview20130916) run 'git git' display index. run 'git <command>' display specific commands. cheddar@cheddar-pc ~ $ cd documents/ics168swarch/ cheddar@cheddar-pc ~/documents/ics168swarch $ git init initialized empty git repository in c:/users/cheddar/documents/ics168swarch/.git / cheddar@cheddar-pc ~/documents/ics168swarch (master) $ git add . warning: lf replaced crlf in assets/prefabs.meta. file have original line endings in working directory. warning: lf replaced crlf in assets/prefabs/pellet.prefab.meta. file have original ...
Read more

multithreading - OPAL (Open Phone Abstraction Library) Transport not terminated when reattaching thread? -

-
i in process of writing application using opal makes h323 calls. have looked online number of working examples , have managed put resembles should like, @ present able call external ip via application when accept call craps out , dies. leaving me with: 0:12.949 setupcall:8752 sert.cxx(259) assertion fail: transport not terminated when reattaching thread , file d:\voip\software\opal\src\opal\transports.cxx, line 1021 passertfunc(0xde3f88, 0xffffffffd228226f, 0, 0) + 0x82 passertfunc(0x10d6e5f8, 0x3fd, 0, 0x10d6eb98) + 0x15b opaltransport::attachthread(0xde5870, 0xffffffffd22fc76b, 0, 0) + 0x96 h323connection::setupconnection(0xffffffffd22fc713, 0, 0, 0xde6ea8) + 0x196 asynchcallsetup(0x10d3572c, 0, 0, 0xdd0108) + 0x7c pthread1arg<psafeptr<opalconnection,psafeptrbase> >::main(0xffffffffd2282faf from have deduced, perhaps incorrectly if there thread lock issue caused (possibly arising fact application sending expected h323 call, throwing in c...
Read more