Unable to populate the dropdown list of a queried label in Web Data Entry
Article ID: KB0074361
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.0 and higher |
Description
When a label is created with sample list queried from a Statistica spreadsheet that was added to Enterprise, it fails to populate the drop-down list of the sample query in Web Data Entry.
For instance, the column "loc" in the web data entry is supposed to query value from a database connection that links to a Enterprise spreadsheet. However, clicking the dropdown list, it doesn't populate any value.
The issue is due to integrated authentication. When referencing the Spreadsheet with the Spreadsheet OLE DB provider, it will be referenced by the web data entry service from a service account. As such, the integrated authentication will not work.
Issue/Introduction
Environment
Resolution
Provide explicit credentials in the Database Connection of an account that has access to the Enterprise object/spreadsheet.
Feedback
