Jump to content

Live data in Reports... How to handle without Schedule updates


Recommended Posts

Hi All,

My report is connected to SAP HANA with around 1 millions rows, where User want this report to be live data without schedule updates and data caching.

When I develop this report without any UI, it is loading slow when User clicks the link of the report. So User does not want this too.

So is there any way to handle this situation.

Thanks in advance.

Link to comment
Share on other sites

Hi HS,

If caching is not an option, and data is loading slow, I would say the best option is the use of an automation job that exports data to library (.sbdf file) which is then used in the dashboard.

In case your query would normally take 5 minutes to load the 1 million rows, you could refresh your automation job each 5-10 minutes. The dashboard can the be build on that .sbdf file and it loads really fast (seconds). And every 5-10 minutes, the data is refreshed so your users will have the latest data with a 5-10 minutes latency.

Kind regards,


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...