Author Topic: how to setup time hierarchy?  (Read 829 times)

Offline lostmytoy

  • Full Member
  • ***
  • Posts: 9
  • Forum Citizenship: +0/-0
how to setup time hierarchy?
« on: 25 Mar 2010 01:35:11 pm »
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