If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to setup time hierarchy?

Started by lostmytoy, 25 Mar 2010 02:35:11 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

lostmytoy

25 Mar 2010 02: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
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite