Hi,
Am loading data from a text file to Essbase target application. Everything fine until exporting data, but the check report is not getting generated and am getting the following error:
Error encountered while connecting to Essbase.
The rule logic I have used for comparing source and target values is:
def runVal:
msg="
dbVal=abs(~,Mar-18,,,RE-001,,,,LE-Monitor,Hyd,Actual,,,,,,,,,,,,,,~)-(|,Mar,,,,RE-001,,,FY2018,LE-Monitor,Hyd,Actual,,,,,,,,,,,,,,|)
if dbVal==0:
RESULT="True"
msg='Trial Balance is balanced'
else:
RESULT="False"
msg='Out of balance'
return [RESULT,msg]
Can anyone help me out on this pls..?