Skip to Content
author's profile photo Pranjal Bora
0
Pranjal Bora

Graphical Calculation View

Posted on Aug 21, 2016 at 03:07 PM 20 Views

Hi All,

I have SES value (field X ) in table ESSR & corresponding IR value ( field Y) in table EKBE . However, sometimes IR may be done at later stage & at that time , I need to pick SES value ( field X) from ESSR table . i.e If Y is null then pick X or else pick Y . How can I address this using graphical calculation view ? Thanks in advance .

BR,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Florian Pfeffer
    Florian Pfeffer
    Posted on Aug 21, 2016 at 03:11 PM
    0

    Join your tables using a join node and in the projection create a calculated column which uses the "if" and "isnull" function. Check the documentation Miscellaneous Functions - SAP HANA Modeling Guide for SAP HANA Web Workbench - SAP Library for the details of the functions.

    Regards,

    Florian

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2016 at 05:54 PM
    0

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.