Skip to Content
avatar image
Former Member

Help needed on SAP HANA Studio

Hello Everyone,

I have some questions related to SAP HANA Studio.

1) How to change Max rows from 200 to 5000 in Data Preview?

2) While creating graphical calculation views, I could not add more than two tables in "join", "union" operations.

    How can I add more than two tables or views in "join", "union" operations?

3) In SAP Hana Studio and modeler view, we have an element called ‘Projection’ (join, union, aggregation of calculation view).

    When working with ‘Projection’, I can only add two objects(joins, unions etc) to it.

    Why only two objects allowed? How can I add more than two objects to ‘Projection’?

4) How can I change the data type of a table column in model views(Attribute/Analytic/Calculation)?

5) Is it possible to change the data type of a table column? How?

6) Is there a way to create two index tables on one and the same column of a table?

7) In SAP HANA Studio, how to create outer joins on two different tables using SQL queries?

Please help me in resolving the above queries.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 13, 2014 at 10:55 AM

    So you really need to go on a training course for SAP HANA - this will all be covered. Alternatively it is all in the HANA documentation in http://help.sap.com/hana

    1) Preferences -> SAP HANA -> Runtime -> Result -> Maximum number of rows displayed in result

    2) This is by design. You can use a Star Join as of Rev.70 in the output node for multiple tables.

    3) This is by design.

    4) By changing the data type of the underlying table or creating a calculated column.

    5) ALTER TABLE <TABLENAME> ALTER (<COLUMNNAME> <NEWTYPE>)

    6) This question doesn't make any sense

    7) Yes, using SQL or SQLScript

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 01, 2015 at 06:33 PM

    in HANA Studio,

    Click on Window -> Preferences -> SAP HANA -> Modeler -> Data Preview

    and then select "No Limit" (might lead to memory issues when previewing large tables)

    You can only select 5000 or no limit depending on your need

    Thanks,

    Sundeep

    Add comment
    10|10000 characters needed characters exceeded