Skip to Content

SAP HANA database views used in calculation views

Mar 09, 2017 at 08:15 AM


avatar image
Former Member


We are trying to use Hana database views in calculation views. But we are getting an error when we want to save and activate the view which it states that there is a model inconsistency and that the database view is incompatible.

The database view is listed as a Row based view so we thought maybe the calculated view requires the DB view to be a column view so we tried to create a column view , which then throws an error that it is not supported.

The SAP Hana db that we are on is SP9


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Mar 09, 2017 at 09:28 AM

Catalog SQL views are not supported as data sources in graphical calculation views.

Also: SPS 9 is outdated for quite some time now, so you might want to look into using a current HANA 1 version, i.e. SPS 12.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Lars

The Client is in the process upgrading to SPS 12.

Just takes a long time in a corporate environment to regression test all the solutions before going to production.

Thanks for the answer