If you created some custom Analytical/Calculation View using HANA Modeling, you can now generate Select SQL from it, with effortless step by step below :
- Open HANA Studio, expand “Content” Tab
- Select Calculation View that you want to generate “Select SQL” statement, right click on it
- Click on “Generate Select SQL” option.
Then, a new SQL Console window will be opened with generated Select SQL automatically.
Also read relevant SAP Business One Tips:
- SAP B1 Delete Draft Error: Approval Process Restriction
- Paper Size Settings in SAP Crystal Reports Guide
- Setting Background Color for Specific Sections in SAP Crystal Report
- Create Cube with Query in SAP HANA (Part 2)
- Print Login User Name in SAP B1 Crystal Report
- How to Create UDO Template for SAP B1 Data Import
