Skip to Content

Updated on Apr 30 2018

This document is to introduce the SAP HANA Model Package Tool for SAP Business One. The relevant how to guide and tool download are available as the attachment in the note below. You should read the how to guide document in the note for detail.

Note 2008991 – SAP HANA Model Package Tool for SAP Business One

SAP HANA model management function is available in SAP Business One, version for SAP HANA and SAP Business One, analytic powered by SAP HANA, which allow you to:

  • Import and deploy the HANA models to the customer system, and the schema and package is pointed to the customer system dynamically,
  • Enable the selected Calculation View for Interactive Analytic with Excel Pivot table, which will list the menu of Interactive Analytic in SAP Business One modules
  • Enable the selected Calculation View exposed through Service Layer, which will be accessible through Service Layer(Available since B1H 9.3 PL02)

The whole life cycle of SAP HANA Model lists below:

  1. Design and test the models with SAP HANA Web-based Development Workbench or SAP HANA studio
    During design time,  a fixed schema or attribute/analytic/calculation view may be used, which need to be replaced dynamically when deploying to 
    the customer system.
    After designing SAP HANA models, you need to package the models according to the HANA model package defined by SAP Business One, and deploy them to the customer’s system. This process involves the following steps.
  2. Export the models from SAP HANA.
    The model to be exported should be active and able to preview correctly in HANA Studio, and the dependent models should be included. The exported model files still use the fixed schema or package name as design time, which can’t be imported directly in customer’s HANA system with HANA Studio.
  3. Package the models into a ZIP file as defined by SAP Business One
    You are recommended to use the SAP HANA Model Package Tool for SAP Business One to package the models. The Package Tool provides a wizard for updating the model files, and the XML information file is created automatically.
  4. Import and deploy the model package with HANA Model Management of SAP Business One into the customer’s  system.
    HANA model management can be found through the menu path below:
    Administration->Setup->General->HANA Model Management.
    Follow the procedure in HANA model management
    -Import the model package from step 2
    -Select the “IAEnabled” AnalyticView/CalculationView, and enter the menu caption to be displayed in Interactive Analytic Menu of SAP Business One
    -Deploy the model package 
  5. Consume the models withe analytic tools with Interactive Analytic, Pervasive Dashboard, Crystal Report etc.
    The selected “IAEnabled” AnalyticView/CalculationView in step 3 are displayed in Interactive Analytic Menu of SAP Business One, end user already can do the interactive analytic with excel pivot table.

    For pervasive dashboard, crystal report connecting to HANA studio, please refer to the relevant e-learning materials.

If you have any question regard to the tool, please post here.

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Giorgi Abulashvili


    While deployemnt new calculation view(cube) in “SAP HANA Model Management” there is an error:

    in the log file, in the “Administration Console for SAP Business One analytics”, ithere is this text:

    “2018-07-13 11:50:44|ERROR|MODEL_DEPLOYMENT|Cannot activate model [sap.bdodemo/COSTACCOUNTINGANALYSISQUERY] which references some retired views: [sap.bdodemo/COSTCENTERANALYSIS,sap.bdodemo/DocumentDate,sap.bdodemo/DueDate,sap.bdodemo/GLAccount,sap.bdodemo/GLAccountLevel,sap.bdodemo/PostingDate,sap.bdodemo/ProjectCode] ; turn on the compatibility mode or remove the dependencies. For more information, see SAP Note 2000521|”

    1. Yatsea Li Post author

      Hi GG

      You view is dependent on some retired view sap.bdodemo/DocumentDate,sap.bdodemo/DueDate,sap.bdodemo/GLAccount,sap.bdodemo/GLAccountLevel,sap.bdodemo/PostingDate,sap.bdodemo/ProjectCode.

      Please use the new view from semantic layer instead, these view are all located in sap.bdodemo.admin package

      sap.bdodemo/DocumentDate -> sap.bdodemo.admin/DocumentDate

      sap.bdodemo/DueDate -> sap.bdodemo.admin/DueDate

      sap.bdodemo/GLAccount -> sap.bdodemo.admin/GLAccount

      ,sap.bdodemo/GLAccountLevel -> sap.bdodemo.admin/GLAccountLevel

      ,sap.bdodemo/PostingDate -> sap.bdodemo.admin/PostingDate

      ,sap.bdodemo/ProjectCode -> sap.bdodemo.admin/ProjectCode

      If you need more information about the predefined views in semantic layer, please refer to the official document. How to Work with Semantic Layers in SAP Business One 9.0 and 9.1 (s-number login required)

      Kind Regards, Yatsea


Leave a Reply