Hi ,
In a chart i display based on two date prompt , this has to be convert to drill up and drill down .Like year to quarter, quarter to month , motnht to week .... this can be without dimension model ??? this can be implemented in report itself ? or by drill through it can be achieved ?
any time you want "drill-up/down" ...yes, this has to be dimensionally modelled. It cannot be constructed in a report.
you could try to hack something together with drill-through, but it would be silly to do so.