Count Aggregate Function on Identity Column -
02-13-2004
, 05:37 PM
I'm just starting to tinker with Analysis Server 2000 so please bare with
me.
I created a cube from an Issues Tracking database. The fact table is
"Issues" which has a primary key column, IssueID (which is an identity, int
column). I created a measure using this column and changed the "aggregate
function" to "Count". I added a dimension of "Issue Type". Then processed
that cube. I chose MOLAP as the data storage type and then processed the
cube.
No data shows up in the IssueID measure? Very frustrated now. Any help much
appreciated!
Thanks,
Chad |