I created time dimension (month->day->hour) in the framework manager; each level is unique; when I’m dragging the level day to the report and executing it, Cognos engine injects the month level to the select. I want to disable it somehow, since I'm trying to use Oracle query rewrite mechanism, which is being misled by the month level. Does anybody know if it is possible? if not is there a way to change the report SQL at runtime using the SDK?