Skip to Content
-1

Complex Logic in Procedure/Table Function in Graphical Calc View

Hello Experts,
Please advise the way for this problem.
This is related to Graphical Calculation view and procedure.


1) I have 2 data sources A and B both have same structure. I have to combine this data and filter out the records based on one condition.


2)Output of step 1 I need to use and generate more records from them and pass it to next layer in Calc View.


I have 2 dates - document date and clearing date and need to add one custom date.
I need to generate records till my custom date equals clearing date.


Eg.
Original record - 
Record   DocNumber  DocumentDate  ClearningDate
Record1  100000020  20181110      20181113
Record2  100000021  20181111      20181113

Required output - 
Record  DocNumber   DocumentDate  CustomDate   ClearningDate
Record1 100000020   20181110      20181110
Record2 100000020   20181110      20181111
Record3 100000020   20181110      20181112
Record4 100000020   20181110      20181113      20181113
Record5 100000021   20181111      20181111
Record6 100000021   20181111      20181112
Record7 100000021   20181111      20181113      20181113 

Solution :
I have created graphical Calc view. 
1. I have added two sources A& B with help of Union node.
2. With help of Join node I have successfully filtered the output based on a condition 
3. 
I am struck at this point 3, Table function or procedure? How to pass the Join node output to this ?
And How to pass the output of Tablefunction or procedure to next node in the graphical calculation view.
Thank you for the expert help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 30, 2018 at 12:56 PM

    If you are working with XS Classic than table functions can be "only" used as data source w/o the option to pass a tabular input (e.g. the result of your join node). With XS Advanced passing tabular input parameters to table functions within calc. views is possible since HANA 2.0 SPS01.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 30, 2018 at 01:36 PM

    Hi Florian ,

    Thank you for the reply, we are using HANA 2.0 SP01.

    If possible please provide a link or example for XS Advanced passing tabular input parameters to table functions within calc. views

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 05, 2018 at 03:59 PM

    Thank you for the link, we are using XS Classic.

    Add comment
    10|10000 characters needed characters exceeded