SSAS 2008R2 MDX Script -


i have problem mdx script ,i'm trying aggregate 2 sets using sum function

basically, have 2 calculated member give me date range window

members in mdx script follow :

create member currentcube.[measures].[numberofweeksinperiodly]     count(descendants([date].[retail calendar].currentmember.lag(2),3),includeempty)-1; // 1 give me 15  create member currentcube.[measures].[startingweekly]    (descendants([date].[retail calendar].currentmember.lag(2),3)).item(0).member_key;   //this 1 give me 130;  create  member currentcube.[measures].[endingweekly]      cint([measures].[startingweekly]+[measures].[numberofweeksinperiodly]); //this give me 145

what im trying is:

within mdx script have: 

scope([date].[retail calendar].[retail semester].members);       [date analysis - retail calendar].[test53weeks] =       sum(         {            (              descendants              (                [date].[retail calendar].currentmember,3              )             .item(1).lag(53)             )     :        [date].[retail calendar].[retail week].**item([measures].[endingweekly]))**      }       ,[date analysis - retail calendar].[current time period]   );  end scope;

if hardcode value on [date].[retail calendar].[retail week].item(145) work, got correct aggregation however,

if use [date].[retail calendar].[retail week].item([measures].[endingweekly])) not work, if calculated member ([measures].[endingweekly]) contain indeed value of 145, got whole level aggragated instead ...

so far have tryed strtomember,strtotuple,strtoset functions, have tried explicitly cast int (cint(([measures].[endingweekly])) same result...

any thought of hek wrong?

thanks

rick


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more