#15763: Support for Calculation Views in SAP HANA

aniltexascowboy reported 2019-11-27T16:54:51Z · last modified 2020-04-30T13:29:19Z

Support for Calculation Views in SAP HANA

Dev	Lwaugh
QA

Priority	Major
Complexity	Complex

Component	DB - Sap Hana
Version	Future

The prospect is looking for support for Calculation Views.

We use SAP HANA for our enterprise data warehouse. I noticed that I can only see objects that are visible under the Catalog area in SAP HANA. I cannot see objects that are visible just through the Content area.

6 attachments

Script_Object.png

2020-04-29T23:42:56Z

132 KB
Query_Builder.png

2020-04-29T23:42:56Z

91 KB
ColumnView_AutoCompletion.png

2020-04-29T23:42:56Z

187 KB
Column_AutoCompletion.png

2020-04-29T23:42:56Z

208 KB
Right-Click-Menu.png

2020-04-29T23:42:56Z

183 KB
Enable-Column-View.png

2020-04-29T23:43:09Z

76 KB

All Comments (2) Change History

tomconrad 2019-12-16T20:54:25Z

More information... https://www.youtube.com/watch?v=n1Xymh4ykRk&feature=youtu.be

nhilam 2020-04-29T23:49:02Z · (edited)

We will add the following functionalities for Columns Views objects:

Auto completion in the query editors: ColumnView_AutoCompletion.png, Column_AutoCompletion.png
Enable the following right-click menu options: Right-Click-Menu.png, Script_Object.png
- Select Top 1000 Rows
- View Properties -- the "Source" should be blank since the definition is not available.
- Script Objects to (Window/New Window/File) As ==> SELECT
Query Builder -- expose column view objects in the View panel: Query_Builder.png
Add "Server Properties > Advanced > Enable Column View objects in Query Builder" option (default = unchecked). The user must enable this option in order for the column view objects to show up in Query Builder. Enable-Column-View.png

Search Tips

Aqua Data Studio / nhilam

Support for Calculation Views in SAP HANA

6 attachments

Issue #15763

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Support for Calculation Views in SAP HANA

6 attachments

Issue #15763

Completion