ACS + Insight Engine (say, 1.4)
Also create a ODBC connection using CDATA driver.
1. Using this ODBC connection as DSN, run the following query in Excel
2. Run the same query using Tableau,
The following error is returned.
Unable to execute the query, error caused by: Unknown field '*'.
The issue does not seem to be qith CDATA driver as with excel, it returns the results.
Considering tools like Tableau provide working with measures and functions such as count(field) count, tried to change the query to:
select SITE, cm_name, `cm:content.size` from alfresco
in order to build the dashboard using Tableau features.
But 2 issues were seen:
1. count(field) isn't supported for Insight Engine hence an error is shown
2. count shows up as null
In order to support BI tools like Tableau, support for the count functions may be required.
|Add / implement automated tests to test count(field)||Done||Unassigned|
|Support for field alias in aggregated fields||Done||Unassigned|