on 04-04-2016 3:14 PM
Hello Experts,
I had a unique customer question the other day and I am not sure if it can be done or the best approach to take. Any advice would be much appreciated.
Background: The customer has built a development web application which uses multiple HANA views to display different reports used by management. The views are built on tables which are updated daily.
Problem: While demoing the reports from week to week to management they want to be able to display the same output on their application even if the underlying data had been changed. So basically they want to be able to cache all the view outputs from today and display them weeks from now, even though the underlying data changes. I have read about Caching in HANA and I believe its purpose to be for more for enhancing query execution time for complex querries rather than taking snapshots of the views. After the demo period is over they won't have a need for this and will go back to their live views.
Any ideas on what can be done here?
Thanks,
Connor
You're confusing cache with snapshots.
Your customer wants to see snapshots of data.
That can be implemented in different ways - caching is not one of them.
History tables would also not be the right choice here.
Most likely you'd need to implement some form of as-of reporting parameter in the models, so that only data relevant to the reporting period is considered.
The other, more rigid but also less flexible version, would be to actually store the results of the calculation views in a snapshot table and report off of that, if required.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Lars. As you suggested, we may end up having an input/filter to only display the data up to a certain point such as month end. I know most of the data has year/month, but I have to check if all of it does. Hopefully it is doable.
The snapshot table option would really be a pain in the neck, but I guess the best option if the first isn't doable.
Why did you say history tables is not the right choice? Is it because these two options are easier?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As I understand you want to compare weekly performance using web application. Why can't you simply filter data based on weeks or dates during the demo and after that remove filter.
or create optional input parameter to set week or date.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Connor,
Please have a look at below link.
http://help.sap.com/saphelp_hanaplatform/helpdata/en/89/da8d4432a44b75a7b43b4cf5d190ce/content.htm
Hope this will help you.
Regards,
Rashmi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The Cache Invalidation feature is exactly what we do not want to happen. I see the invalidation period can only go for one day. So after one day the cache will be invalidated. We want to be able to see the data for a month ago. Your link lead me to look at the HANA History capabilities but that requires me to change all the underlying tables to History tables and I'm not sure if that is a possibility at this point.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.