Stack Overflow
Stack Overflow

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

Conditional update on HANA Studio (SQLScript) trigger

I would like to write a trigger on HANA Studio using SQLScript to update COLUMN_E from TABLE2 when COLUMN_B from TABLE1 is updated to a specific value (let's say, 100). Rows from table 1 are referenced in table 2 with the first column (ID). I have…
Nicole
  • 107
  • 1
  • 2
  • 12
0
votes
1 answer

Trigger to update specific row from table SAP HANA

I am trying to create a trigger on Hana Studio to update a given registry (column F2 from table T2) when an update happens in table T1. A row from T1 is referenced in table T2 with the column X1 (that is, X1 in T1 is equal to X2 on T2). What I would…
Nicole
  • 107
  • 1
  • 2
  • 12
0
votes
1 answer

Sap HANA Studio change SAP GUI resolution

I can't change the SAP GUI resolution, can't find the option. I've changed the font size scaling factor to the minimum that is 80%, under Window->Preferences->SAP GUI Integration, but the result was pretty much the same: The menu and icons are too…
Usr
  • 2,628
  • 10
  • 51
  • 91
0
votes
1 answer

How to add tables in object privileges for a role

I am looking for a SQL command which will help me add multiple tables in object privileges for a new role in SAP HANA Studio. Currently I am adding tables for a role using following sequence. In SAP HANA Studio, I create a new role from…
Prasan Shetty
  • 49
  • 3
  • 15
0
votes
2 answers

Calculated Year in Group by

I am working on ABAP CDS view and stuck somewhere, actually i have date and amount field and i have to show sum of amount year wise, but when i run below query it didnt group by on year and show year multiple time @AbapCatalog.sqlViewName:…
Arun Gupta
  • 31
  • 2
  • 8
0
votes
1 answer

Sum of sub query in cds view

I am unable to sum of data in cds views. Earlier in Hana calculation view the below query give me result as per my desire Select t1.ID, t1.Name, t1.qty, t2.amount from T1 Inner join (select ID, Name, Sum (amount) from t2 group by ID, Name) as T2 But…
Arun Gupta
  • 31
  • 2
  • 8
0
votes
1 answer

How to save an R randomForest object within SAP HANA Studio?

I'm pretty new in SAP World and I’m trying to work with R Server installed within SAP HANA Studio (Version of HANA Studio : 2.3.8 & Version of R Server 3.4.0) My tasks are: Train the randomForest model on R Server within HANA Studio (with help of…
KayEd
  • 3
  • 2
0
votes
2 answers

How to sort Fields in calculation view without Rank Node

Is there any way to sort fields in Calculation View, We can sort fields in Data Preview but it is limited to 200 or some number of rows but how to apply sorting logic in calculation view only.
vikas parmar
  • 11
  • 2
  • 3
0
votes
2 answers

Using a table function with no importing parameters in a HANA graphical calculation view

I'm wondering if someone can help me decipher this Hana Studio Error. I'm very new to this, so apologies if this is just me being simple. I'm trying to use table functions, just something simple for starters (i.e no params in, table out). The…
mitch_au
  • 323
  • 1
  • 2
  • 9
0
votes
1 answer

Inventory Ageing Calculation view in Hana Studio

I want to make a calculation view in hana studio where I have to maintain ageing of product which is pending in Inventory. It will subtract on first come first basis...I mean in case of Product P001 then 5500 will subtract 1000 first then balance…
Arun Gupta
  • 31
  • 2
  • 8
0
votes
2 answers

How to insert bytestrings into HANA

I am trying to insert two byte strings into a HANA table with VARBINARY columns, but I keep getting a syntax error, e.g. SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "G\xa2ac\xa0av\xf6": line 1 col 98 (at pos 98) My two byte…
AOyung
  • 13
  • 4
0
votes
2 answers

SAP Vora: Not able to add Vora table as Virtual table via Smart Data Access in HANA Studio

I'm using a VM with HANA Express 2 SP 01. On a small test cluster I installed the Hortonworks Data Platform 2.6 with Spark 1.6.3, and also added HANA Vora 1.4 and the Spark Controller 2.1. I followed the SAP Vora Installation and Administration…
D. Müller
  • 3,336
  • 4
  • 36
  • 84
0
votes
1 answer

how to call a JSView from an XSJS file?

I know I can call other JS files from XSJS by making a .xsjslib file. I would like to be able to call a JSView instead. Is this possible? Note: the reason for me to this is that I can then use the SAPUI5 libraries and make it easier to import…
polaris
  • 339
  • 2
  • 14
  • 33
0
votes
2 answers

How to know the URL of my OdataService in SAP HANA?

I created an oData service within Hana Studio. I'd like to access it from a sapui5 application, but I don't even know what the url is supposed to be so I can't test it. Does anyone know how to build this url? I know you need hostname and port…
Louis
  • 11
  • 1
  • 10
0
votes
1 answer

Hana Studio: How to execute file1.sql out of master.sql file?

I am completely new to HANA DB as we just start to migrate our smaller SAP Netweaver java Applications to HANA from Oracle I am currently working on finding out what to consider, playing around on sandbox level with try&error running the scripts,…
Gian-Marco
  • 23
  • 7
1 2
3
4