olap - Specify a particular foreign key field as a link between two tables in the SSAS data source -


i quite new sql server analysis services , try build first cube (the first except adventure works tutorial)

the problem how specify particular field in table serve link table, when several options (several keys pointing same second table) present.

in data source have department table: (irrelevant fields omitted)

| department_key (pk) | ...

and discipline table this:

| discipline_key (pk) | title | department_for_key (fk) | department_of_key (fk) | ...

both foreign keys in discipline table point department table , both constraints specified in db. still meaning quite different.

when constructing discipline dimension in sql server data tools specify of foreign keys should used link between levels of particular hierarchy in dimension (or in whole dimension), haven't found way explicitly.

interestingly, happens ssdt (or ssas) uses column want ( department_of_key ) relate levels. nevertheless, use second key in separate dimension (or in new hierarchy in same dimension) in future, it'll better know how control process.

although, suppose question simple one, have failed find solution far. have feeling there relevant in tutorial devoted ssas, couldn't find there.

thank response!

(i appreciate recommendations regarding better title question =) )

i avoid relying on relationship definitions in ssas - results obscure , difficult debug ref post.

i build sql view (ideally ssas use only) covers entire scope of each dimension. can tested independantly , fed ssas predictable results.

using sql views has advantage of insulating cube schema changes , data issues (e.g. nulls).


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more