Fix data in the elasticube, if it is different from the one in the MongoDB data source [Linux]
You found that the data type is different from the one you have in data source, lets fix it. L2025.*
Step-by-Step Guide
In our example, you have float/decimal values in the MongoDB. But for some reason, in the Elasticube, we got integers.
To fix this issue, go to the data tab, press Connection Management (more information about this here https://docs.sisense.com/main/SisenseLinux/data-source-connection-management.htm)
Find the connector you used for this elasticube and press edit.
Scroll down to the 'Sampling Count' option.
This option is responsible for the following. During the creation of the elasticube, it scans the first 100 records and determines the type of column for the elasticube based on the values.
If the first 100 records are integers, the whole column will be marked as an integer.
Even though all other values are floats.
To fix this issue, just change the option - Sampling Count to 1000 or 10000.
Save the connector and build the elasticube.
Conclusion
It is an easy way to solve this issue and understand more about how the system works.
Disclaimer: This post outlines a potential custom workaround for a specific use case or provides instructions regarding a specific task. The solution may not work in all scenarios or Sisense versions, so we strongly recommend testing it in your environment before deployment. If you need further assistance with this, please let us know.
