What are adhoc reports and static reports?
Adhoc reports run in real time based on the input parameters provided by the user at the run time.In Microstrategy, adhoc reports are created using Prompts. In static reports, users won’t be provide any input parameters.These reports are usaully schedule to run overnight and ready to view immediatley in the mornings using cache.