SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Related measures


Related measures

Author
Message
mdmckiernan
mdmckiernan
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 57
I have two related tables in my DSV. The first table called Test has a primary key column called test_id which is an integer data type. I have successfully created measures and the accompanying dimensions on this table. I have a second table called test_details which has a primary key of test_details_id. It also has a column called test_id which is a foreign key on the primary key column test_id on Test. The relationship is one (test) to many (test_details) I have also successfully created measures and the accompanying dimensions on this table as well. What I am struggling with is to find a way to "roll up" or relate the test_details dimensions to test. I believe this is possible. I am just not sure where I am coming up short. I have tried intermediate tables. I have established (I believe) all the necessary relationships in the DSV to have these tables "see" each other but to no avail...

Puzzled Mike
Paul Williams
Paul Williams
Right there with Babe
Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)

Group: General Forum Members
Points: 789 Visits: 882
I am not entirely sure what you are trying to do by your description, but essentially if I understand it you have two fact tables.

What are you exactly trying to do when rolling-up. Are you trying to roll-up the measures in the child table to analyse by the same dimensions as in the primary table. If this is the case you could have combined the tables to create a single fact table.
This only works though if the dimensionality of these measures is all at the same grain. If not you will need two separate fact tables. If this is the case then ensure that both fact tables have the appropriate dimensions to analyse by. If this happens to be the same dimension then use conformed dimensions.

Paul R Williams.
mdmckiernan
mdmckiernan
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 57
I am looking to connect the TestDetails dimensions to the test measure. Sorry if my initial posting was not clear.
Mike
Attachments
test detail.bmp (6 views, 488.00 KB)
Paul Williams
Paul Williams
Right there with Babe
Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)Right there with Babe (789 reputation)

Group: General Forum Members
Points: 789 Visits: 882
"I am looking to connect the TestDetails dimensions to the test measure".

Then you either need to combine the tables as I indicated so that you have one fact table. All dimensions can then be assigned to this fact table. You can then roll up from the test details to analyse by all dimensions which I think is what you require.

However, as I have also described as they are different grains this may not be feasible and you would need to be careful of the dimensionality of the primary table. In this case you can have separate fact tables but you would need to add the dimension information related to the test details to the test measure.

Do this in the DW if this exists. If not this should be possible by using the abstraction layer of the dsv and using a named query.

Paul R Williams.
mdmckiernan
mdmckiernan
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 57
Thanks Paul: I see now the granularity between the two tables is my issue. I am going to modify the view to include the dimension attributes from both tables...Mike
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search