excel - Year to Date and Quarter to Date calculations in SSAS -


i building ssas cube financial data , have ytd (year date) , qtd (quarter date) calculations. beginner in this, have googled around. many advice not use built in time intelligence, instead create mdx calculations. have read more , tried build using example. works, not sure if not overdoing it. also, use cubeformulas in excel extract values, current formual bit complicated, contains array... here example of excel formula : (=cubemember("servername";{"[dim date].[calhierarchy].[year].&[2014].&[2].&[4]"\"[timecalc].[timecalc].[ytd]"})) .

and here actual calculation script added cube:

calculate;     -- create calculated members create member currentcube.[timecalc].[timecalc].[ytd]  null,  visible = 1;   create member currentcube.[timecalc].[timecalc].[qtd]  null,  visible = 1;      -- scope specific measures   scope({[measures].[amount]});     scope([dim date].[quarter].[quarter].members,[dim date].[date key].members);         -- qtd calculations     ([timecalc].[qtd]=         aggregate(               crossjoin({[timecalc].[current period]},                 periodstodate([dim date].[calhierarchy].[quarter],                 [dim date].[calhierarchy].currentmember)                     )             )     );         end scope;   scope([dim date].[year].[year].members,[dim date].[date key].members);         -- ytd calculations     ([timecalc].[ytd]=         aggregate(               crossjoin({[timecalc].[current period]},                 periodstodate([dim date].[calhierarchy].[year],                 [dim date].[calhierarchy].currentmember)                     )             )     );         end scope;      end scope;

i have created 1 dimension called timecalc, linked main time dimension called "dim date". simpler if create 2 separate dimensions? 1 ytd calculation , 1 qtr calculation? perhaps retrieve formula not have complicated array structure?


Comments

Post a Comment

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more

javascript - Add class to another page attribute using URL id - Jquery -

i have attached id url. ex: when click link 1 , has #tab-2 id , takes me landing page. in landing page have find element has #tab-2 id have add class .active . i tried no luck. please 1 correct code. thanks js fiddle link html <div class="menu"> <ul> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-2">link 1</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-44">link 2</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-74">link 3</a></li> </ul> </div> landing page <div class="tab"> <ul> <li><a id="tab-2" class="active" >link 1 content</a></li> <li><a id="tab-44" >link 2 content</a></li> <li><a id="tab-74" >link 3 content</a></l...
Read more

firefox - Where is 'webgl.osmesalib' parameter? -

i'm trying webgl running on firefox (v37.0.2) via software acceleration mesa. tried following steps have been stated in article: http://www.binarytides.com/enable-webgl-firefox-ubuntu/ however, unable find parameter named ' webgl.osmesalib ' in about:config section? has been removed (or renamed)? if yes, how should instruct firefox use mesa's software acceleration webgl? looks support osmesa removed in favour llvmpipe.
Read more