Framework:FKT TimeDimTypeFlag
From CoPlanner 10
Jump to navigationJump to search
Function
FKT_TimeDimTypeFlag(<ID of the time dimension>)
| Parameter | Description |
| ID of the time dimension | COPSYS_ID of the time dimension |
Result
Y (year), D (day), M (month), Q (quarter) is provided as the result. The data type of the target value is “text”.
Example
Table: bsp_tbl_time functions
Source column: time (Lookupdimension dim_sys_time) = JAN 2004 (20050103)
Function: b01_TimeDimTypeFlag: FKT_TimeDimTypeFlag([bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID])
Results column: TimeTypeFlag (Text(1)) = M
