TimeArrayColumn Property
The TimeArrayColumn property sets or returns the name of the first column in a date array.
Syntax
Column .TimeArrayColumn
Applies To
Discussion
A date array is a group of four or twelve contiguous columns that contain quarterly or monthly transaction values. If you store your transaction data monthly or quarterly, we recommend that you define the columns as members of a date array rather than as individual measures.
Each value in the date column represents the first month of a fiscal year. Each transaction column covers a time period such as month or quarter. For example, to report at the Quarterly level, your data source may include rows similar to this:
DATE,PRODUCT,Q1,Q2,Q3,Q4199901,Product1,100,200,150,400199901,Product2,1110,2265,1995,4200200001,Product1,110,210,160,420After you create a time dimension, return the first column in the array and then use the Name property of the same column object to set TimeArrayColumn. You must also set the TimeArrayType and TimeArrayStartMonth properties. Transformer automatically adds the other columns to the array and sets their data class to trDataClassArrayMember. Finally, add only the first member of the array to the Measures collection. If you have more than one array, add the first member of each array to the Measures collection.
Type
String
Access
Read/Write