Cube Design

-

i have 2 fact tables - main , comments

fact main data in following format

videoid     score

a           1

b           2  

c           3  etc

 

fact_comments have videoid key fact_main , comments each video , score each comments ( fact_main had granularity of videos, video score  and fact_comments has granularity of comments comments score)

fact_comments:

videoid   commentid     score

a               aaa                 2

a                bbb               3

a              ddd                 1

b vvv                4

etc.

 

now want cube in see together. bascilly want integrate fact_main , fact_comments . tried having cube 2 measure groups. didnt work. instance, when select video id, instead of getting corresponding commentid, got comment id's. please let me know how dimension usage between these 2 tables be. 

 

alos have many otehr dimensions shared across these 2 fact tables, dim_user.  teh user id of dim_user mapped uploader of fact_main , [name of person made comment] in fact_comments. how supposed treat case?

thanks,

ck


in case, can create dimension table video id , comments associated each id.  these can configured in cube 1 dimension 2 attributes.   still keep 2 tables described above, each @ different level of granularity.

perhaps if create user hierarchy using:  comments -> video



javier guillen
http://www.msbicentral.com/blogs/javierguillen.aspx


SQL Server  >  SQL Server Analysis Services



Comments

Post a Comment

Popular posts from this blog

Motherboard replacement

-
running windows 10 technical preview, need replace motherboard can run the  sysprep  command restoring pc ? or there easier  or more preferred way ? thanks if replace motherboard within same family of chipsets (i.e. intel > intel or amd > amd), should okay restarting pc twice. carey frisch Windows 10 Insider Preview  >  Windows 10 Insider Preview General
Read more

Cannot create Full Text Search catalog after upgrading to V12 - Database is not fully started up or it is not in an ONLINE state

-
in order access new full text search capiblities of sql azure, upgraded our azure sql v12. (a day later), when try create new catalog: create fulltext catalog mycatalog default i following message: msg 9972, level 16, state 100, line 1 database not started or not in online state. try full-text ddl command again after database started , becomes online. hi scott, apologies inconvenience caused you. known issue on service side , fix going included in next update. specific case mitigated, should able use full-text search syntax now. thanks, mihaela Microsoft Azure  >  Azure SQL Database
Read more

Remote Desktop App - Error 0x207 or 0x607

-
hi all, i manage windows 2012 r2 network, including connection broker, session hosts , remote apps virtual servers.  i've used remote desktop app on own android phone, no issues @ - connects published gateway url , can login , access network. we looking move business onto nokia handsets ms operating system (currently on blackberry), not able connect via remote desktop app on nokia lumia handset. setup, per android config , brings remote apps , remote desktop screen, know can connect.  when select remote desktop, shows following process: initiating remote connection securing remote connection certificate can't verified - choose connect it digitally signed cert (digicert sha2), pc name different physical connection broker name (inherited domain name old gov project - can't publish publicly) initiating establishing securing connection error have been 0x207 getting 0x607 a bit baffled, work on android (and ipad @ home using app). assume ms use d...
Read more