Which version of the same measure would result in faster querying from resulting cube (or would they have the same query speed)?
Define the measure as a count distinct of <FactX> in the fact table.
Create a dimension table with a primary key of <FactX>, and define the measure as a count of rows of this table.
Note: <FactX> has many levels: Count(Distinct FactX)/Count(*) ~ .8
Convert DTS to SSIS |
Document SSIS |
30+ SSIS Tasks |
Real-time SSIS Monitoring |
Quick Starts |
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?