View or View on Demand

When to give access level View or View on Demand?




View access level


User’s benefit

1. User can see the html report page which was saved when last refreshed.
2. They don’t have the refresh report option enable.
3. They can do all the report operation without touching the database.

System’s benefit

1. When user refreshes the report the generated SQL query directly goes to database and ran it in database server. If they get the view access only they the system overload will be less as there will not be simultaneous run (same report in same point-of-time with multiple login) for the same query for different users.
2. It reduces number of hit to database server.
3. It reduces the network traffic.
4. Report instance which a user is using having full capability ( like drill down , snapshot… ) but those activity will not send any SQL to Database server. It will go to the report server to get the copy of data saved in last refresh.
5. There will be no chance of atomicity problem if we scheduled the report refresh after the regular database refresh.

Developer’s burden
Developers need to do the following:

1. Either they need to schedule all the reports with proper prompt value so the reports can refresh automatically according to the prompt and return the proper data.
2. Or they have to manually refresh the reports before the users’ starts using everyday. It may be daily, weekly, monthly, and yearly, quarterly or user assigned.

View On Demand access level
User’s benefit

1. Users will get access to the real-time data.
2. They can refresh their own report by changing the condition.
3. Users will get the accurate data till the second of their refreshing time.
4. Response time may be decreased but the accuracy of data is more perfect.
5. User can change the condition of the report.
6. If the reports are scheduled then the user have both choice to see the refreshed report or refresh it again to see the last minute update.

System’s benefit or Burden:

1. Number of database server hit will be more.
2. In time of yearly or quaterly closing the network traffic will be most.
3. The same query will run thousand times for different users.

Developer’s burden or benefit:

1. Need to tune the database and do the performance testing continuous.
2. Do a perfect load balancing.
3. No need to scheduled the reports or no need to refreshing and saving the reports.