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

Dimension with multiple levels hierarchy

Started by Rosanero4Ever, 19 Oct 2012 02:34:53 AM

Previous topic - Next topic

Rosanero4Ever

Hi all,
I'm a newbie about TM1 and I'm reading many tutorial (above all IBM documents and the book "TM1 Cookbook") but I have some problems to develope a dimension having a hierarchy with multiple levels.
In my environment, I have a table in Sql Server as reguard as time with the following columns:
- year
- quarter
- month
- day

Dates in this table are between 01-01-2000 and 31-12-2020

I use Turbo Integrator process to create in TM1 a time dimension with the above hierarchy but the result isn't that I hoped :
process groups  quarters so, e.g. in the 2010 1st quarter, I see all the dates are in all 1st quarters (all years)
Does anybody can advice me some videos or  tutorials that can guide me simply?
I'm reading many documents that build the hierarchy in excel but they don't help me.
Thanks in advance for your time