 | |
Re: Question for experts..
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Question for experts.. -
02-17-2005
, 12:02 AM
|
Hi, I think you should create a view on your factor table. The problemId should be unique in the view. Thanks, Vladimir Chtepa "AshVsAOD" <.> wrote in message news:#rW5yO8EFHA.2676 (AT) TK2MSFTNGP12 (DOT) phx.gbl... I have a table that lists the following... Fact Table: ProblemID Date.. The ProblemID is unique... However I need to join this table to a factor table that may have some ProblemID's listed twice... Also to this main "Fact Table" I need to join a table with priorities.. this table may have some problemID's listed twice.. This is obviously giving me double ups... How do I make it keep the actual count of the problems... say 200 problems from the fact table, while adding the extra information in a cube form as a Dimensions... My question is this.. I need to know the number of problems, what problem has what priorities etc... How? Thanks in advance... |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.