sql server - MS Analysis Cube - one-to-many joins -


i building olap cube in ms sql server bi studio. have 2 main tables contain measures , dimensions.

one table contains 

date | keywords | measure1

where date-keyword composite key.

one table contains looks like

date | keyword | product | measure2 | measure3

where date-keyword-product composite key.

my problem there can one-to-many relationship between date-keyword's in first table , date-keyword's in second table (as second table has data broken down product).

i want able make queries when filtered given keyword:

                                measure1    measure2    measure3 ============================================================ tuesday, january 01 2013        23          19          18 ============================================================     bike                        23     car                         23          16          13     motorcycle                  23                               caravan                     23          2           4        van                         23          1           1

i've created dimensions date , producttype i'm having problems creating dimension keywords. can create keyword dimension affects measures second table not first.

can point me tutorials doing sort of thing?

turns out first table had one row null values (a weird side effect of uploading excel file straight ms sql server db). because value cube trying apply dimension null in 1 row, whole cube build , deploy failed no useful error messages! grr


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