Where are my date ranges in Analytics coming from?
- by Jeffrey McDaniel
In the P6 Reporting Database there are two main tables to consider when viewing time - W_DAY_D and W_Calendar_FS. W_DAY_D is populated internally during the ETL process and will provide a row for every day in the given time range. Each row will contain aspects of that day such as calendar year, month, week, quarter, etc. to allow it to be…