Hi,
I have some reports scheduled to run Every morning 5:30
Before that there is an ETL process which will load the data in warehouse tables.
i have a Analyze schema script running 7:00 morning.
Surprisingly, the report refresh do not start untill 7:05. So i schduled the anlyse schema at 5:15 and the report refresh starts at 5:30.
Is there any dependency for report refresh and Analse schema?
TIA,
Push
I have some reports scheduled to run Every morning 5:30
Before that there is an ETL process which will load the data in warehouse tables.
i have a Analyze schema script running 7:00 morning.
Surprisingly, the report refresh do not start untill 7:05. So i schduled the anlyse schema at 5:15 and the report refresh starts at 5:30.
Is there any dependency for report refresh and Analse schema?
TIA,
Push