We currently at a client busy doing a customer age analysis report.
We need to filter all the data on an input key date i.e. posting date <= input posting date.
Now how do we use a Variable (using SAP Hana Studio) based on a posting date column and apply the operand <=?
In SAP HANA Studio, we cannot seem to find the place to reference and use the Variable when defining a Restricted Measure!
Anybody have a solution for this?
It's pretty urgent, as the customer wants to purchase Hana, however this feature needs to be able to do this.
Your help will be very much appreciated!