In the previous blog SAP HANA: Handling Dynamic Select Column List and Multiple values in input parameter have shown on how to select multiple values for filtration using "Replace" function in procedure.
In that document, we went to procedure approach, since the user needs the dynamic output based on input conditions.
But if the output is static column list, you wouldn't want to use procedure, so in this blog will be explaining on how to achieve the same functionality of handling multiple values filter condition on a graphical calculation view using "Projection".
Problem Description:
Giving the flexibility of choosing the values he wishes to see in the report and then pushing the filtration logic to the lowest level possible.
In that document, we went to procedure approach, since the user needs the dynamic output based on input conditions.
But if the output is static column list, you wouldn't want to use procedure, so in this blog will be explaining on how to achieve the same functionality of handling multiple values filter condition on a graphical calculation view using "Projection".
Problem Description:
Giving the flexibility of choosing the values he wishes to see in the report and then pushing the filtration logic to the lowest level possible.
