Forum Discussion

Sunkari's avatar
Sunkari
Icon for Responsive Resident rankResponsive Resident
9 years ago

Small observation regarding time series analysis

Hi All,   I have following model. Fact_Table(Revenue,Date(Datetype),Datekey(Integer))----(100,"2017/01/01",20170101) DimDate(Date(Datetype),Datekey(Integer))---("2017/01/01",20170101)     I ca...
General Comment
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Sunkari

 

Context is a very complicated concept and is a powerful tool that makes the limited number of functions to do more. As far as I know, "Datekey" usually is a bridge to create relationships. The actual "Date" column will be used in the report. Hope this would help.

 

Best Regards!

Dale

  • Sunkari's avatar
    Sunkari
    Icon for Responsive Resident rankResponsive Resident
    9 years ago

    v-jiascu-msft Thanks for inputs.