mdx - Is it possible to collapse several similar nodes of different branches in a hierarchical dimension? -



mdx - Is it possible to collapse several similar nodes of different branches in a hierarchical dimension? -

let's have next hierarchy utilize dimension: root a1 b11 b12 ... b1n b1special a2 b21 b22 ... b2n b2special ... am bm1 bm2 ... bmn bmspecial under each of "b" nodes there several more nodes @ different levels. each leaf of hierarchy has measure associated (sum of fact f). possible mdx have sum of , items children of "special" nodes?

i have assume want see sum of 'special' nodes once, @ root level. in other words, want see 1 number in results set.

assuming hierarchy detailed in original question called 'bob', , had dimension called 'kate', might seek this...

with fellow member [bob].[only special levels] 'aggregate( filter( {[bob].[name of level holds b members].members}, instr(1, [bob].currentmember.name, "special") > 0 ) )' select {[kate].defaultmember} on rows, {[measures].[whever want see aggregated]} on columns [cube name] ([bob].[only special levels])

this creates new, temporary, fellow member in bob dimension, aggregation of several other members in bob dimension. start members sit down in 1 particular level. filter chooses members have word "special" in name.

note instr vba function supported microsoft ssas. returns 0 if chosen string not found. alternative string searching functions may available in other flavours of mdx.

you utilize new fellow member in where clause, , slap other dimensions/measures wherever want.

mdx hierarchy dimension

Comments

Post a Comment

Popular posts from this blog

php - Edges appear in image after resizing -

php - Edges appear in image after resizing - i have implemented next function: private static function generatepicture($sizekey, $src, $initialwidth, $initialheight, $imagetype) { $destination = adimage::addsizekey($sizekey, $src); if (file_exists($destination)) { return; } $finalsize = adimage::$sizes[$sizekey]; $initialratio = $initialwidth / $initialheight; $finalratio = $finalsize["w"] / $finalsize["h"]; $newimage = imagecreatetruecolor($finalsize["w"], $finalsize["h"]); imagealphablending( $newimage, false ); imagesavealpha( $newimage, true ); $oldimage = imagecreatefromstring(file_get_contents($src)); if ($initialratio >= $finalratio) { $scale = $finalsize["h"] / $initialheight; $surpluss = abs($initialwidth - ($initialheight * $finalratio)); imagecopyresized($newimage, $oldimage, 0, 0, $surpluss / 2, 0, $finalsize["w"], $finalsize[&q
Read more

ios8 - iOS custom keyboard - preserve state between appearances -

ios8 - iOS custom keyboard - preserve state between appearances - i'm having performance problems custom keyboard i'm working on. loading words in spell correction tree takes quite bit of time. seems done each time keyboard appears - there way preserve state of keyboard? apps can suspend / resume etc - can't find documentation on how extensions, or if there's mechanism doing att all. thanks! you loading dictionary net or disk? first case nsuserdefaults, encoding (nscopying) options store info. can load in background. according docs, os typically kills extension process, so, think there no way prevent keyboard objects deallocation (you may utilize nskeydarchiver). ios8 ios-app-extension custom-keyboard
Read more

Delphi change the assembly code of a running process -

Delphi change the assembly code of a running process - i'm trying alter address 00741fa5 has push test.009e721c . alter push test.009e71c8 . procedure callback; asm force $9e71c8 end; procedure tform2.btn1click(sender: tobject); var ppid :dword; pprocess : cardinal; begin getwindowthreadprocessid(findwindow(nil,pchar('test')), @ppid); pprocess := openprocess(process_all_access, false, ppid); injectasm(pprocess, $741fa5, 10, integer(@callback), 0); end; here injectasm function (with error checking) function injectasm(process: longword; injectaddress, injectsize, codeaddress, codesize : integer): pointer; var csize, rsize : integer; replaced : array of byte; jmp : array [0..4] of byte; jmpaddress : integer; nopv : byte; : integer; nbr: ulong_ptr; begin //injectsize must equal or greater 5, because need space our //(far) jmp wwxxyyzz instruction //if there's no space, inject in place of few instructions if injectsize &
Read more