Analytics Software

Hi all,

On top of the hour the following processes occur in our Planning application:

- Datapush from Workforce cube to Opex cube (5 minutes)
- Data export (calc script) from Opex cube and load (essbase load rule) into ASO reporting cube (5 minutes)

During these 10 minutes, when a user runs a business rule in the Opex cube, it kills the datapush and the data export processes.

Is there a way to utilize the @RETURN @HspMessage to disable the users to run this business rule? If statement would be like this:

IF(Data push is in process)
@RETURN( @HspMessage( "Data is currently being pushed from Workforce cube to Opex cube. Please run this business rule in 10 minutes"), ERROR);
ENDIF

OR

IF(Data export calc script is in process)
@RETURN( @HspMessage( "Data is currently being pushed from Opex cube to ASO reporting cube. Please run this business rule in 10 minutes"), ERROR);
ENDIF

If there is no way to track the data push or a calc script through a business rule, I think SYSTEMTIME could also be used since the business rule kills the process only in the first 10 minutes of the hour. So the IF statement would look like this:

IF(SYSTEMTIME {wMinute} < 10);
@RETURN( @HspMessage( "Data is currently being pushed from Workforce cube to Opex and ASO reporting cubes. Please run this business rule in 10 minutes"), ERROR);
ENDIF

Thanks,
Mehmet