DataNAV: Please clarify the differences between “Update items” vs “Refresh” vs “Refresh All”
I manually edited the name of a item that was brought over from an XML Data Source via DataNAV, and also changed a value that was brought over via DataNAV. If I right-click on the Category tile and choose DataNAV->Update Items, I would expect that the item name and value reverts back to the original name (since my XML Data Source remains unchanged). But it doesn’t do anything.
If in the Data Sources panel I right click on my data source and choose “Refresh”, then the item name and value reverts back as expected.
But why does right-clicking on the Data Source name give me options “Refresh” and “Refresh All”, while right clicking on any column within that Data Source only give me “Refresh All”? Seems counter-intuitive (as does “Add Data Source” appearing when right-clicking on a Data Source column).
This will be changing a bit with the new iteration of data import in a 2019 release… and we will try to make this more clear in the UI (it is admittedly confusing) but a lot of the concepts will be the same.
DataNAV uses an internal database that we refer to as a “column store”. This is not part of the model file, but is local to your computer and optimally configured for fast performance.
The data flow goes from your data source (csv, xml, database) to the internal columnstore… then from the columnstore to your Quantrix matrix.
I think the different refresh options are well explained in the Quantrix help. Here is a link:
https://quantrix.com/help_resources/modeler/webhelp/#t=Updating_DataNAV_Queries.htm