cannot get the data provider outline
I was trying to create a analytical view in SAP HANA with the help of following guide.
I could not open data preview and received following error
SAP DBTech JDBC:  (at 119): invalidated view
After searching on SDN, I found following solution at http://scn.sap.com/thread/2043153
grant select on schema <SCHEMA> to SYSREPO with grant option;
grant select on schema <SCHEMA> to <USER>;
I successfully executed first statement but kept failing to execute second one. I was getting error. After reading the error message and SAP note I realized that I was logged in as SYSTEM so I do not have to execute second statement. I only needed this if I am allowing other users.
Silly, but I learnt something new.