
1. Re: Ratio at beginning of period
FTisiot Jan 14, 2015 8:05 AM (in response to 2804071)Hi,
If ratio is always between Y, Y1 and Y2 you could:
a) Create the measure "Avg Salary"
b) Create the measure "Avg Salary Y1" with the Ago Function based on Avg Salary
c) Create the measure "Avg Salary Y2" with the Ago Function based on Avg Salary
d) Create the measure Ratio Y1/Y2 as 1("Avg Salary Y1"/"Avg Salary Y2")
e) Create the measure RationY/Y2 as 1("Avg Salary Y"/"Avg Salary Y2")
If you want to extend this method to an infinite nr of years and use ALWAYS by default the 1st year you can create a measure named "Avg Frist Year" that has First Aggregation method on the time dimension while keeping the Avg on all the other dimensions. Set the level to Dim Date Total. Then divide the Avg Value of Current Year by the Avg First Year.

2. Re: Ratio at beginning of period
2804071 Jan 15, 2015 5:40 AM (in response to FTisiot)Thank
The demand is dynamic, so the first solution does not meet the requirement.
Dם you have another idea to implement the report?
I do not want to solve it through the ADMIN because this is a lot of fields that I'll have to make this change

3. Re: Ratio at beginning of period
FTisiot Jan 15, 2015 8:07 AM (in response to 2804071)Can you try with what suggested before?
If you want to extend this method to an infinite nr of years and use ALWAYS by default the 1st year you can create a measure named "Avg Frist Year" that has First Aggregation method on the time dimension while keeping the Avg on all the other dimensions. Set the level to Dim Date Total. Then divide the Avg Value of Current Year by the Avg First Year.
You could also solve this in the frontend by doing something like
"Measure"."Salary" *100/SUM(CASE WHEN RANK("Dim Date"."Year" ASC) =1 then "Measure"."Salary" end)