Does anyone knows about best practices for nested calls in store procedures?An example:SP_1(PARAM1){Do something;}SP_2(PARAM2){SP_1(PARAM2);}SP_3(PARAM3,PARAM4){SP_2(PARAM3);SP_2(PARAM4);}is or isnt a good practice? THANKS.
In this blog post we are going to learn how to create a HANA Database Connection within Pentaho PDI.1) Go to SAP HANA CLIENT installation path and copy the “ngdbc.jar”*You can get SAP HANA CLIENT & SAP HANA STUDIO from : https://hanadeveditionsapicl...
Try,1)Create input parameters for your 500 Products CV like this.2) Use this parameters to filter your data in a script calculation view (PARENT)I declared and used variables for catch filter values in my PARENT CV , I used same input parameters in m...