Requirement : Based on user input or current month , we want to restrict data in our view. Common requirement is to show last 12/13 months data dynamically. In general , we want to go 'n' number of months back from current month or whatever month user would select.
Solution : From SPS09 , HANA allows Input Parameter of type "Derived From Procedure /Scalar Function" - and I would use this to meet this requirement. Good thing about this solution is , we can restrict the data at the first projection node and avoid bringing unnecessary data to upper nodes. We shall write a procedure which would take month input from user ( or current month if nothing supplied) and return "to" and "from" month.
Solution : From SPS09 , HANA allows Input Parameter of type "Derived From Procedure /Scalar Function" - and I would use this to meet this requirement. Good thing about this solution is , we can restrict the data at the first projection node and avoid bringing unnecessary data to upper nodes. We shall write a procedure which would take month input from user ( or current month if nothing supplied) and return "to" and "from" month.
