Two Time Dimensions in Fact-Table 1

[farhy]

Hi,

I have two time dimensions in a fact-table:

eg: FK_Date_ID_Sold_at
FK_Date_ID_Imported_at
FK_Product_ID
Value

If I join the table with two differnt Time tables, (alias on Time table) I get the data doubled.

How can I handle the two time dimensions in BO, without creating two differnt fact tables?

regards
farhy

 

[blom0344]

That problem should not occur if the time-table stores unique dates. You should check the universe how cardinalities are set. Each record from facttable should reference only one record from the timetable.
If that is okay, it does not matter how many times you use time aliasses (is that the right plural?) on the facttable..

Ties Blom

 

[skrandel]

You need to look at the raw data.

Without seeing the primary key on the table, it's not possible to see what's going on.

Is the combination of the 3 fields unique?
Is it possible to have multiple "sold_at" values for an "imported_at"?


Steve Krandel
Symantec