OBIEE 11g r 5 CriteriaValidator.dependentColumnExists

[John Minkjan (OBIEE101)]

I'm prepping a new blog article but I can't get dependentColumnExists
to work for tables only.....

According to the documentation this: (http://download.oracle.com/docs/
cd/E21764_01/bi.1111/e10541/answersconfigset.htm#insertedID5)

function validateAnalysisCriteria(analysisXml)
{
// Create the helper object
var tValidator = new CriteriaValidator(analysisXml);
// Validation Logic
if (!tValidator.dependentColumnExists("Base Facts", "", "Time", "Per
Name Year"))
return "You selected a measure so pick Year!";
return true;
}

this should work....
I can get to work for !tValidator.dependentColumnExists("Base Facts",
"Revenue", "Time", "Per Name Year").
but not for !tValidator.dependentColumnExists("Base Facts", "",
"Time", "Per Name Year") or !tValidator.dependentColumnExists("Base
Facts", "", "Time", "").
Who can help with a working example?

regards

John

http://obiee101.blogspot.com/
http://obiee11g.com/