Excerpt:
Click here to read the rest.I thought I'd spend a bit of time talking about the advantages of using the SYS Date Lookup cube bundled with the Flow Server Manager. This cube has been invaluable to me during past implementations and is worth considering as a starting point for any project.
Time Travel for TM1 Rules?
Sometimes your rules and TI processes need to time travel. There are many scenarios where this is necessary. but I'm sure if you've got a few projects under your belt, you won't need me to provide an example.
TM1 provides some basic calendar and time functions to deal with calculations that need to factor in the fourth dimension of our physical reality. However, they fall well short of those offered in Excel and other programming environments, and often you just can't find an efficient way to do what you want.