Hi All,
We need to tag a flag to every element in a dimension with the result of a date calculation. We need to check if (Today's date - Start date) > n, then Flag = 'Y' else 'N' etc. The start date is an attribute of the dimension. How do we do this in TM1?
Regards,
Deepu.
Date calculation in a dimension.
-
deepu_sree
- Posts: 29
- Joined: Tue Jun 22, 2010 4:01 pm
- OLAP Product: IBM TM1
- Version: 9.5
- Excel Version: 2007
-
lotsaram
- MVP
- Posts: 3656
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Date calculation in a dimension.
This is quite a straightforward requirement. Have you read the Date and Time Rules Functions section of the TM1 Reference manual?