prompts Archive

Performance Tip: Use Static Prompts

If you have any prompts on a report, chances are that they include a time reference prompt variable like year and/or month. In most cases they refer to a time dimension table or similar

Performance Tip: Run Prompts Upfront

Run Prompts Upfront. In most data warehouse environments, data does not change during the day. This means prompt values do not change during that period. So it is a waste of time and server