I have to write a code in transformation to check for 3 status. Based on the value, i have to calculate a value.
In the future, if more statuses are added, I will have to change the existing code in transformation. Somebody had told me you can use TVARV to keep your options dynamic but I dnot know how to use them in BI.
Can anybody help ?