Example Report in DataDirect folder???
I'm trying example report in DataDirect folder (file Hourly_Master.xls).
I have a variable as picture 1.
I need change default variable in report file but I don't know how to correct it (picture 2).
I try replace "ACI4_12,VALUE" by "Int1, Value" but all data display "#NAME?"
Help me please,
Please check the step below
1. Check the job logs in scheduling structure what error/ warning message you are getting.
If you are getting Job Action : Action Aspect Completed, /Warning ; could not get Excel ( Data Direct not installed ?)/Export file:Completed
2. It means data-direct is not installed properly " best practice is to install the data-direct in service account not in User Account ", Uninstalled Data direct and Installed again using Service Account in the Aspect server.
Check weather you have done the macro settings of Excel "disabled all macros except digitally signed macros" in the service user account.
You must logon to the service user account and do this settings and also remove and add the datadirect addin manually.