Time filter for the MDX metric applies to the day dimension. To use the time filter for your metric, you must define how the days dimension from the cubes is rendered in Insight. Use the OlapTimeFormat.xml file to specify the rules. For the information on how to locate and handle the file, see MDX metrics. Insight always expects the keys for filtration in the format YYYYMMDD.