ISSUE:
At times a user will run into an issue when trying to use a macro for filtering the data coming from an Excel sheet. When using the curr macros Excel does not relate the data back to a proper Excel Date format and will give you an error similar to below.
Example Error:
An error occurred while retrieving the data for the
chart : [Microsoft][ODBC Excel Driver] Data type
mismatch in criteria expression..
CAUSE:
The cause of this issue is the Microsoft Excel Driver handling of the data conversion.
RESOLUTION:
When adding your curr macro to the filters add them like shown below, this will handle the conversion for you so that the issue does not come up.
DATEVALUE('${currdate}')
All you will need to change is the macro type, and the integration between the Excel driver and iDashboards will work smooth.
Comments
0 comments
Please sign in to leave a comment.