每当用户尝试运行分析时,Oracle Analytics 都会调用函数 validateAnalysisCriteria。您可以定制 validateAnalysisCriteria,以便基于您自己的特定标准来验证和阻止查询。如果此函数返回 true,则查询可以运行。如果此函数返回 false 或显示一条消息,则系统会阻止查询。
例如,以下是一个名为 myblocking.js 的 JavaScript 程序的示例代码。
// This is a blocking function. It ensures that users select what
// the designer wants them to.
function validateAnalysisCriteria(analysisXml)
{
// Create the helper object
var tValidator = new CriteriaValidator(analysisXml);
// Validation Logic
if (tValidator.getSubjectArea() != "Sample Sales")
return "Try Sample Sales?";
if (!tValidator.dependentColumnExists("Markets","Region","Markets","District"))
{
// If validation script notifies user, then return false
alert("Region and District are well suited, do you think?");
return false;
}
if (!tValidator.dependentColumnExists("Sales Measures","","Periods","Year"))
return "You selected a measure so pick Year!";
if (!tValidator.filterExists("Sales Measures","Dollars"))
return "Maybe filter on Dollars?";
if (!tValidator.dependentFilterExists("Markets","Market","Markets"))
return "Since you are showing specific Markets, filter the markets.";
var n = tValidator.filterCount("Markets","Region");
if ((n <= 0) || (n > 3))
return "Select 3 or fewer specific Regions";
return true;
}
如果此函数返回的不是 false,则系统会认为标准有效并运行分析。此函数还可用于验证针对预览和保存操作的标准。