Skip to Content
author's profile photo
Former Member

SAP HANA database views used in calculation views


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


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on 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.

    Add comment
    10|10000 characters needed 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