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.

50 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
  • 360
  • 2
  • 12
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
  • 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
  • 561
  • 3
  • 18
  • 45
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
  • 79
  • 5
2
votes
1 answer

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
  • 31,937
  • 2
  • 37
  • 57
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
  • 6
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
  • 16,046
  • 33
  • 87
  • 157
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
  • 79
  • 5
1
vote
2 answers

Conditional SQL queries with SQL Script

I have two example tables: TABLE1: ID | COLUMN_B| COLUMN_C _________|_________|_________ 1 | 0 | 1 ________|_________|_________ 2 | 0 | 1 ________|_________|_________ 3 | 0 | …
Nicole
  • 137
  • 1
  • 3
  • 11
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
  • 3
1
vote
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 field "X1" (that is, X1 in T1 is equal to X2 on…
Nicole
  • 137
  • 1
  • 3
  • 11
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 meant.…
vikas parmar
  • 11
  • 1
  • 3
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
  • 16,046
  • 33
  • 87
  • 157
1
vote
2 answers

HANA Calculation View Filter

Ok so I feel like a numpty asking this, but .. How do I apply a filter within a calculation view ? My view has 1 source table, an Attribute View. I have added the attrib view to a Projection. Then I've been searching everywhere to apply a simple…
SimonB
  • 557
  • 5
  • 20
1
vote
2 answers

SAP DBTech JDBC : Feature not supported : Scalar UDF does not support SQL Statement

I'm new at HANA Studio, so please excuse me. I am getting an error while creating function in SAP HANA Studio. Here's my function : CREATE FUNCTION "PAYROLLDBTEST".GetAbsenteeismDays ( -- Add the parameters for the function here EmpID…
mark
  • 561
  • 3
  • 18
  • 45
1
2 3 4