Dear All,
I have Oracle Hyperion Planning 11.1.2.4 with updated patch 900, I want to restrict user to do not exceed Amount and Due Date, I have a member of "Due Date" and "Limited Amount", I want to compare user cost with Limited Amount and Due Date with System Date, so I'm using this calculation :
"Cost LCC"(
IF("Cost LCC" -> "Demanded" < "Limited Amount" -> "Demanded-Budget")
@RETURN("Data do not Saved due to Exceed Amount.",ERROR);
ENDIF;);
Also try :
"Cost LCC"(
IF("Cost LCC" -> "Demanded" < "Limited Amount" -> "Demanded-Budget")
@RETURN(@HspMessage("Data do not Saved due to Exceed Amount."),ERROR);
ENDIF;);
"Cost LCC"(
IF(@ToDateEx("mm/dd/yy",@FormatDate(@Today(),"mm/dd/yy")) < "Demand Budget Due Date" -> "Demanded")
@RETURN("Due Date Passed.",ERROR);
ENDIF;);
Also :
"Cost LCC"(
IF(@CalcMgrGetCurrentDate() < "Demand Budget Due Date" -> "Demanded")
@RETURN("Due Date Passed.",ERROR);
ENDIF;);
These calculations show the message but it does not restrict user to do not save data, I don't want the user to save data if the amount exceed or due date passed.
I also tried INFO and WARNING but no luck, Also tried to assign previous value :
"Cost LCC"(
IF("Cost LCC" -> "Demanded" < "Limited Amount" -> "Demanded-Budget")
"Cost LCC" -> "Demanded" = "Cost LCC" -> "Demanded-Budget";
@RETURN("Data do not Saved due to Exceed Amount.",ERROR);
ENDIF;);
Also try :
"Cost LCC"(
IF("Cost LCC" -> "Demanded < "Limited Amount" -> "Demanded-Budget")
"Cost LCC" -> "Demanded" = "Cost LCC" -> "Demanded-Budget";
@RETURN(@HspMessage("Data do not Saved due to Exceed Amount."),ERROR);
ENDIF;);
"Cost LCC"(
IF(@ToDateEx("mm/dd/yy",@FormatDate(@Today(),"mm/dd/yy")) < "Demand Budget Due Date" -> "Demanded")
"Cost LCC" -> "Demanded" = "Cost LCC" -> "Demanded-Budget";
@RETURN("Due Date Passed.",ERROR);
ENDIF;);
Also :
"Cost LCC"(
IF(@CalcMgrGetCurrentDate() < "Demand Budget Due Date" -> "Demanded")
"Cost LCC" -> "Demanded" = "Cost LCC" -> "Demanded-Budget";
@RETURN("Due Date Passed.",ERROR);
ENDIF;);
Please help me to achieve my requirement. Also tell me if I'm going wrong or if there is any other function to do that.
Thanks & Regards
Ismail Junaijo