Question: what is the difference between variable and input parameter in sap hana?
Answer: The difference is that, variable defines a filter on an attribute of the view. So it is always assigned to an attribute. whereas parameter defines an internal parameterization of the view. ie the engine needs to know it and uses the parameter value during execution to find calculated measures.