Time Dimensions issues.. sql2005 -
11-15-2005
, 12:18 AM
Hi all,
I am having an issue with my time dimension. I have created a time table in
SQL that has a unique key etc... I can link this table to my fact table
through SQL fine. However, when I create the time dimension in AS2005 I get
the total in each member.
So 2004 Sales will be 4000
as will Q1 of 2004 as will 1st of May 2005
etc.
What am I doing wrong? |