I need to edit the values in a Straight table Dimension. I have two tables. Employee and Standalone table (Refer attachment).
In the salary table for Example the Employee AAA's base branch is Japan and Current Location is China and having a salary 1100.
Now I need to change the base branch and Current location value in the table for same Employee AAA to USA & UK and the salary would now become 1800.
In the same way in need to change/simulate different Base branch and Current location for different employee and see how their salary differs.
How could this be done? Any suggestions... Please help..