The following error message occurs in SAP Analytics Cloud (SAC):
- SQL Error: Unauthorized SQL, only SQL SELECT statements are supported. when using Freehand SQL to create model with SQL Database Import Connection
- SAP Analytics Cloud
Reproducing the Issue
- Create Model using SQL Database Import Connection
- Create New Query and select Freehand SQL
- Manually type in an SQL statement starting with "With"
- Click Create
- "Unauthorized SQL, only SQL statements are supported." message appears
SAC only supports SQL statements that start with SELECT. In addition, modify statements such as INSERT, DROP, DELETE are also not supported.
Change SQL statement to start with SELECT and/or ensure there are not modify type statements in the SELECT.
Consider following and voting on this enhancement request https://influence.sap.com/sap/ino/#/idea/249226
- 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?
- Search for SAP Analytics Cloud content using Google or Bing:
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- 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, Connection, Sac, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Import, Failed, Using, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, FHSQL, fhsql, sql, freehand, SQL error, , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , How To