How can I add an attribute to TIME dimension?
TIME filter is pre-defined and designed in such a way that it would not allow adding any new attribute to it. As an illustration, if the days (monday, tuesday etc) are required to be shown in the TIME filter then, we can create an attribute called 'Day Name' that will point to the DAY_NAME column in the DIM_DATE table and use this attribute while publishing the KPI to get the output in desired manner.