As we have mentioned in Chapter 4, Rules, it is extremely important to be aware of and understand the following information about the sub-tabs of the Advanced tab:
When you run a TI process, the procedures are executed in the following sequence (basically left to right as they are displayed):
Prolog
Metadata
Data
Epilog
Prolog is executed one time only.
If the data source for the process is None, Metadata and Data are disabled and do not execute.
If the data source for the process is None, Epilog executes one time immediately after Prolog finishes processing.
If the data source for the process is not None, Metadata and Data will execute for each record in the data source.
Code to build or modify a TM1 dimension resides in the Metadata tab.
The Metadata tab is used to build TM1 subsets.
All lines of code in the metadata procedure are sequentially executed for each record in the data source.
All lines of code in the data procedure are sequentially...