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
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
  • 962
  • 1
  • 14
  • 36
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
  • 623
  • 3
  • 21
  • 54
0
votes
0 answers

Get Month number in calculated column using column engine

I have the following fields: Subscription = Semi Annual, Quarterly, Monthly. Start Date = (Jun 1,2023, Jun 10,223) I want to build a calculated column using IF statement (column engine) and month function (SQL) such as: IF("Subscription"='Semi…
Petra Palmer
  • 1
  • 1
0
votes
0 answers

How to retrieve HANA View comment from HANA Studio

After creating a view in HANA, it is possible to add a comment at the view level, or at the column level with the command : COMMENT ON VIEW "view_name" IS 'view comment'; COMMENT ON COLUMN "view_name"."col_name" IS 'column comment'; Column comments…
HANAGB
  • 13
  • 4
0
votes
1 answer

Sap hana studio how to alter a datetime field to always have the current date

as the title says, how do i make this field to show me, as default, the current date? I was trying to use this command: ALTER TABLE "SBO_JC_TST"."ORDR" ALTER (U_Competencia TIMESTAMP, DEFAULT CURRENT_DATE) but it keep giving me this error: Could…
ADM2 CWB
  • 1
0
votes
1 answer

Error while selecting the calculation view through variables

I am facing one interesting issue while reading from a calculation view through variables ... the code is as follows: do begin declare lv_ww nvarchar(6); declare lv_quarter nvarchar(6); select "WORKWEEK","QUARTER" INTO lv_ww,lv_quarter from…
Saurav
  • 48
  • 6
0
votes
1 answer

HANA Studio: Calculated Column with multiple IF-Statement

I have folowing data set in my calculation view: And Im trying create two additional calculated columns for the key ''SAPClient Warehouse TU_NUM": Column should return ''X", if ((TXT04='CHKO') and (STATUS_VALUE='X')) AND ((TXT04='CHKI') and…
dyz
  • 57
  • 1
  • 4
  • 17
0
votes
1 answer

Metadata of Calculated columns in HANA

i am looking for any system table where the SQL or the expressions written in calculated columns are stored. Rather than opening each and every calculation view, deep dive using the lineage and check for expression in calculated columns.
karthik d
  • 11
0
votes
1 answer

Can Hana only allow user to view certain row of a view, if a condition is met

I am wondering if the following is achievable with Hana. I want to create a role/analyticPrivilege/user such that, the user can only view a specific set of rows of a view if a condition about the row is met. Let's say I am having a view DEMO_VIEW,…
Man-Kit Yau
  • 149
  • 1
  • 10
0
votes
1 answer

SAP HANA dark theme change sql script text colors/syntax highlighting

I changed SAP HANA studio to the dark theme, but the text in the editor is difficult to see. I've searched through all the preferences for about 30 minutes but I still can't find any way to change this. There are some posts in the SAP Community…
ThomasRones
  • 657
  • 8
  • 29
0
votes
1 answer

Query a table where combinations of fields do not exit?

I apologize for the poorly worded title :( I have three tables. Table MARA: Articles and their descriptions. Table MARC: Article to site assortments. Table T001W: Sites and their locations. I'm trying to find the missing records in MARC that…
user2547757
  • 5
  • 3
0
votes
1 answer

Partial Data deletion from SLT table

I need to delete the data from VBFA table which is an SLt table. We need to delete the data till Oct 2017. How we can achieve this as only date filed we have is MJAHR which is Material document year and ERDAT date on which record is created. How we…
Mayankb024
  • 11
  • 2
0
votes
0 answers

Hana studio - append sign commenting the code

I am using sap hana 1.0 sps12 and hana studio 2.3.8. When i use double pipe '||' as sql append, studio is treating code after double pipe as comment. E.g. select 'A'||'B' from dummy; Hana is treating 'B' from dummy; part as comment. Where can i…
Anirudh D
  • 181
  • 3
  • 14
  • 33
0
votes
2 answers

HANA - Calculate using data from other line

I have a requirement, use attribute view to calculate the result base on condition and value come from another line. If KSCHL = Y then Result will be set from KBETR. If not, Result will be set by it own KBETR * KBETR from corresponding key pair…
Binh
  • 241
  • 1
  • 15
0
votes
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
  • 107
  • 1
  • 2
  • 12
1
2
3 4