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
3
votes
1 answer

need one record in duplicate records

Here is the table: Activity table |Place of order|Order NR | Nr of activity|type of activity| Date of activity| |01 |1 | 00001 | 1 | Date1 | |01 |1 | 00002 | 1 …
sveer
  • 427
  • 3
  • 16
3
votes
1 answer

Providing default value to Input In SAP Hana procedure

I am trying to create a stored procedure in Hana Studio. In the stored procedure ,I am trying to give a default value to the input. my code is, CREATE PROCEDURE defaultSchemaName.procedureName (IN INPUT NVARCHAR(10) DEFAULT 'TEST') This runs fine…
HiteshJolly
  • 55
  • 1
  • 11
3
votes
3 answers

not able to call procedure within procedure in HANA Studio

I am trying to call a procedure I made earlier in new procedure. I am getting error in same line no matter what I try. My original line was : CALL "PAYROLLDBTEST"."ABS_GetEmployeeHistoryDetail"(:EmpID) on this I got error "invalid name of function…
mark
  • 623
  • 3
  • 21
  • 54
2
votes
1 answer

Cannot retrieve column in SAP Hana Studio

I am importing a .csv file using HANA studio, this is what my table looks like: This is what my query looks like: select outage_start from "PIHPJ"."ji_major_storm" and this is the error message: SAP DBTech JDBC: [260]: invalid column name:…
user69355
  • 99
  • 7
2
votes
2 answers

How does one handle exceptions in date casting in SAP's HANA?

QUESTION SUMMARY: What is the proper way within HANA SQL or HANA Studio in a view (Calculation, attribute or Analytic) to handle invalid data when attempting to cast to a date so a user can filter the data? In SAP's table KONM the field KSTBM is a…
xQbert
  • 34,733
  • 2
  • 41
  • 62
2
votes
1 answer

How to get month number or name in cds view

I am creating a CDS view in Hana studio where i want to get month number or name from date (YYYYMMDD) in report, but I am unable to find any function like month or anything else, Please help.
Arun Gupta
  • 31
  • 2
  • 8
2
votes
3 answers

Combine LIKE and CONTAINS in SAP HANA

Consider the following entries in my table: red apple yellow apple apple green red aple appel yellow Several people have populated this table using a non-consistend notation (the color before or after 'apple'), also entering some spelling…
Evgenij Reznik
  • 17,916
  • 39
  • 104
  • 181
1
vote
1 answer

How to backup and restore HANA schema correctly?

Version of SAP HANA Studio is 2.3.37 Require the correct steps to perform backup and recovery of a specific schema in SAP HANA STUDIO Steps performed: For backup, I selected the schema (Right Click->Export). 2.Selected the folder i wanted to take…
Luke
  • 51
  • 7
1
vote
1 answer

How to create a table variable for using in a JOIN?

Because SAP HANA doesn't support CTEs, I'd like to learn to use table variables in joins. I've found simple examples of using table variables in a join in SQL Server, like below: https://www.youtube.com/watch?v=2fc6YUCQSV8 I have not found any…
David Mays
  • 466
  • 4
  • 14
1
vote
1 answer

HANA DB : How to use CONCAT syntax more than 2 fields

I'm using query in HANA Studio , It's work CASE WHEN T0."U_XXX_SalEmp2" is not null THEN CONCAT (T7."SlpName",CONCAT ('+',T0."U_XXX_SalEmp2")) ELSE T7."SlpName" END AS"Sales Emp", But I want to CONCAT more fields **For Example :** CASE WHEN…
Anubise
  • 13
  • 1
  • 5
1
vote
2 answers

SQL Date Range Specification, Explicit vs BETWEEN()

My understanding of SQL is that WHEN reading_start_dt BETWEEN '2020-02-09' AND '2020-02-15' is the same as WHEN reading_start_dt >= '2019-02-09' AND reading_start_dt <= '2019-02-15' But I'm getting completely different ResultSets when the only…
user69355
  • 99
  • 7
1
vote
1 answer

SAP HANA studio open SQL console for current schema

I am opening the SQL console from HANA studio by clicking on the schema but it is not connected to database. How can I configure it so that it will open with current schema?
OptiPro
  • 11
  • 1
  • 3
1
vote
2 answers

When to use HANA SPs instead of graphical Calculation views?

I didn't come across in any such scenario where we have to use stored procedure instead of Calculation View, but I read many sites where it is mentioned. One can use Stored Procedure in complex scenarios, but I am confused which scenarios are…
vikas parmar
  • 11
  • 2
  • 3
1
vote
1 answer

Shortcuts in HANA studio SQL Console/SQL Editor

In SAP HANA Studio (ver 2.2) there is a so called "SQL Console" where you can write your SQL code (sometimes also called "SQL Editor"). There are some keyboard shortcuts to improve productivity with this tool. What I found: F8: execute Query F9:…
Christian4145
  • 513
  • 1
  • 9
  • 31
1
vote
1 answer

Login as SYSTEM into SAP HANA trial instance

Is there any way to login in HANA's trial instance as SYSTEM user? If so, what is the password? I'm only able to login as the default user, but I need more privileges in order to perform certain operations.
Evgenij Reznik
  • 17,916
  • 39
  • 104
  • 181
1
2 3 4