Having problem setup Time hierarchy in MD using Time dimension in Framework model. Seems like each level requires a date value.
My mapping now as follows:
Year = _make_timestamp(fiscal_year, 1,1)
Quarter = _make_timestamp(fiscal_year, quarter, 1)
Month = _make_timestamp(fiscal_year, month, 1)
It passes validation but when execute I got error about year not in range. Any Idea? TIA