Creating alias in physical layer:
Open Rpd in online mode
Go to physical layer and create a alias on SAMP_TIME_DAY_D
Rename as Paid Date
Define primary key for alias table as CALENDAR DATE column.
Go to physical layer and physical diagram create a join
between fact (REVENUE_F) to Paid date.
"orcl".""."BISAMPLE"."Paid
Date"."CALENDAR_DATE" =
"orcl".""."BISAMPLE"."SAMP_REVENUE_F"."PAID_DAY_DT"
No comments:
Post a Comment