HELLO ALL
I have a case in essbase application. I have to calculate Budget value for No. of bookings(which is a driver in my account dimension) for the year 2015 for various Flights( Dimension which contains all the flights which are classified based on UDA's) for a Booking Center(From where the bookings are done for a particular flight) based on the Actual value for No. of bookings for the year 2014 for various flights for a booking center.
Business Logic- If my flight is for middle east( UDA-MEM) then my budget value for 2015 for no. of bookings should be 10 times the actual or else the value should be 2 times the actual. I am using the following calculation script.
FIX("Budget","2015",@DESCENDANTS("Total Bookings"),@LEVMBRS("TotalPeriod",0))
"No. of Bookings" (IF(@ISUDA("Flights","MEM")) "No. of Bookings" = "No. of Bookings"->"Actual"->"2014" * 10;
ELSE
"No. of Bookings" ="No. of Bookings" ->"Actual"->"2014"* 2; ENDIF;);
ENDFIX;
Please feel free to ask the case documented with screenshots.
Please correct me if I am wrong. Please help with expert comments. Thanks in Advance