Make Year, Period in Fact table as a dimension key attribute

Is it possible to make the year and Period in my Fact table as a dimension key attribute ? My current Fact table scheme is :



REATE TABLE [dbo].[FactPERBAL](
        [TRXNO] [int] IDENTITY(1,1) NOT NULL,
       [ACTKEY] [int],
      [ACTINDX] [int] NOT NULL,
      [ACTNUMBR_1] [char](11) NOT NULL,
      [YEAR1] [smallint] NOT NULL,
      [PERIODID] [smallint] NOT NULL,
      [PERDBLNC] [numeric](19, 5) NOT NULL,
      [CRDTAMNT] [numeric](19, 5) NOT NULL,
      [DEBITAMT] [numeric](19, 5) NOT NULL,
 CONSTRAINT [PK_FactPERBAL] PRIMARY KEY NONCLUSTERED
(
      [TRXNO] ASC
))
AXISHKAsked:
Who is Participating?
 
Jason Yousef, MSSr. BI  DeveloperCommented:
I never done that and I don't think it's the best way, but since you don't have a date column, you can create another calculated column using the 2 values of the year and period, and do the same in your time table, set the right relationship and I think that would do.
0
 
AXISHKAuthor Commented:
tks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.