IBM Cognos 8 Platform > Metric Modeling (Metric Designer)

how to setup time hierarchy?


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


[0] Message Index

Go to full version