Questions tagged [hana-studio]

The SAP HANA Studio is an Eclipse-based IDE for SAP HANA.

The SAP HANA Studio is an Eclipse-based IDE for SAP HANA.

SAP HANA Studio is a tool from SAP for database developement. With SAP HANA Studio you can access, configure, manage, administer and develop all components within SAP HANA. The tool includes script editors (like SQL Console), graphical tools (like View Editor for calculation views), monitoring and reporting capabilities.

SAP HANA Studio consists out of different installation parts (Studio, Studio Administration, Application Development, Database Development) which are shown in the IDE in perspectives like SAP HANA Administration Console, SAP HANA Development, SAP HANA Modeler and SAP HANA PlanViz.

58 questions
0
votes
2 answers

SAP HANA - show results in same pane

Does anyone know how to get HANA Studio to show the results at the bottom of the pane instead of as a separate tab?
jmich738
  • 1,565
  • 3
  • 24
  • 41
0
votes
1 answer

Not able to run xsjs file, error: site can't be reached

I am using office network to learn SAP HANA, to connect to HANA system I have to first connect to VPN then only the HANA system gets online. I configured a simple project XS application but when I try to run it, it shows the below error : hana01’s…
Roshan
  • 645
  • 1
  • 11
  • 36
0
votes
1 answer

how to detect HANA studio environment?

I have an sapui5 code on HANA studio and would like to know how I can programatically tell if I'm in Dev, test or Prod environment. Is there a way to do this?
polaris
  • 339
  • 2
  • 14
  • 33
0
votes
1 answer

is there a way to activate the file when saving it in HANA studio?

When working in HANA studio I have to right click and activate my files after I save them in order for them to take effect. Is there a way to set it up so the file is activated when I save?
polaris
  • 339
  • 2
  • 14
  • 33
0
votes
2 answers

Count distinct in SAP HANA graphical calculation view

We have below table as - CUSTOMER_NO ORDER_NO ITEM_NO C1 O1 I1 C1 O1 I2 C1 O1 I3 C1 O2 I4 C1 O2 I2 What I need is count of distinct orders and count of ITEMS per customer - CUSTOMER_NO ORDER_NO ITEM_NO C1 2 (distinct) 5…
Anirudh D
  • 181
  • 3
  • 14
  • 33
0
votes
0 answers

How to activate a dependencies object on test system?

I have a big model with views and procedures implemented in HANA. These Objects are interdependent. On the development System every things work fine. After we Transport the objects using CTS on the Test-System, we got all the objects on Test-System…
ayahya82
  • 374
  • 3
  • 6
  • 18
0
votes
1 answer

First time new user login requires password change in HANA DB

As I login from a new user created through HANA Studio, it asks for Password change. I'm new to the environment and don't know how to disable this.
shubham gupta
  • 321
  • 3
  • 9
  • 23
0
votes
1 answer

Copy SAP HANA project from Amazon Web Service

I have a HANA project hosted on Amazon Web Service. I also have a trial instance of HANA. How can I copy or export my project from Amazon to the trial instance using HANA Studio?
Evgenij Reznik
  • 17,916
  • 39
  • 104
  • 181
0
votes
1 answer

XS engine issue in HANA Studio

I am trying to develop a XS Project. My XS engine is up and running. If I do http://hana.corp:8000, then it is showing that my XS engine is up and running. But I am not able to run the .XS or .html file from the browser as I am getting 404-File not…
sowmya
  • 1
  • 3
0
votes
1 answer

Max Index of Array SAP HANA

Does anyone know how to get the Max Index of an array in SAP Hana (stored procedure). How can I get the Maximum Index via a single call for populated SAP Hana String array. I am looking for something similar to: MaxIdx…
0
votes
2 answers

Not able to create view in HANA

i am trying to create a view by using HANA stored procedure,but unable to do. It's giving error that incorrect syntax near ".". i want to create view by using HANA stored procedure,but unable to do. It's giving error that incorrect syntax near ".". …
mark
  • 623
  • 3
  • 21
  • 54
0
votes
1 answer

HANA Studio locks DB user when accessing HANA in the cloud via database tunnel

I'm using the database tunnel from the SDK of the HANA Cloud Platform to connect to a HANA instance in the cloud. This works fine for the first connection, but I'm having a problem when trying to reconnect after having closed and re-opened the…
oberlies
  • 11,503
  • 4
  • 63
  • 110
-1
votes
1 answer

SQL add table subset for each distinct value in another table

I want to add a subset of a table (t2) to another table (t1) for each customer_id once. t1 represents ordered materials. t2 represents a static table representing high-seller materials. The goal is to create a table with material lists for each…
FaGri
  • 3
  • 3
1 2 3
4