trigger for essbase

can use trigger to monitor data change:

 

CREATE TRIGGER 'Profit'.'Main'.'NBC_Detail'
WHERE (NBC_Detail, Total, Department, Direct_GL, no_detail, budget,final, product,Location, FY12, Jan)
WHEN NBC_Detail<100 THEN MAIL ([email server],[from@emailaddress],[to@emaiaddress],[NBC_Detail])
END;

 

if NBC_Detail data become less than 100, a alert email will be sent out.

can run that in MaxL. or create a trigger in EAS

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8583032/viewspace-716299/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8583032/viewspace-716299/