The following error message occurs in SAP Analytics Cloud (SAC):
- The following columns contain data quality issues
- Validation has detected issues in your full dataset that cannot be solved automaticallly.
This issue occurs with a field that has a scientific notation i.e 445244345e7
- SAP Analytics Cloud (Enterprise) 2020.02
- SAP HANA
Reproducing the Issue
Click on the main menu -> click create model
Select SAP HANA from the connection list under Acquire data
Give the query a name and select the available view
Select all the available data in the query builder
After the model has been created look on the side navigation menu
Click on the 'Model Requirements' expansion panel
Look at the data quality tab and observe data quality issues
Click validate data at the bottom of the side navigation
SAP Analytics Cloud does not directly parse scientific notations via HANA
In the SAP HANA Database model the data type for this field as decimal and not numerical.
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem