Developing Essbase Applications

338  •  Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals

grid = null; cv?.close(); cv = null;

essCube.clearActive(); essSvr.disconnect(); essHome.signOff();

allmatch = true

sqlVals.each{ key, val ->

println "${key}: ${val} vs. ${essVals[key]} match:

${val==essVals[key]}"

if (val != essVals[key]) { allmatch = false }

}

System.exit(allmatch ? 0 : 1)

is script builds two maps with identical keys and veries they have identical values.

Actually, essVals has an extra entry (“Diet”), but we do not test this shared member. We

let sqlVals drive the comparison loop, and that member is not in there.

Since the SQL query part is made up, the only way to get this code to run is to com-

ment out that section and add the li ...