2478386 - Cannot import an Excel file to create a model in SAP Analytics Cloud (BOC)

• Cannot import an Excel file to create a model in SAP Analytics Cloud (SAC) in SAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud / BOC)
• The error "An error exception occurred in the Data Acquisition service." occurs

• SAP Analytics Cloud

1. Create an Excel file with data in Column A-E and Row 1-10 to make a crosstable from A1 to E10.
2. Input any value in a cell that is not next to this crosstable, such as inputting "1" in Cell I2.
3. Log into SAC.
4. Go to Create -> Model ->Import a file from your computer.
5. Choose that Excel file and click Import.
6. The error  "An error exception occurred in the Data Acquisition service." shows.

In this situation, there is a crosstable and a separate cell in this Excel file. So when importing this Excel file, it tries to create a model based on a crosstable and a separate cell. It will fail because it doesn't fit the structure of a model in SAC.

Delete the cell or add the cell into the crosstable.

• Help resources
• Help portal
• SAP community network ( Questions & Answers / Direct Link to Create Question / Blogs )
• SAP community wiki
• Ideaplace forum ( for enhancement requests & new features )
• Video tutorials 
• Videos by topic areas: ( Overview, What's New, Models and Connections, Stories, SAP Digital Boardroom, Planning, Predictive, Collaboration, Administration )
• Training events
• Past event recordings
• New user handbook
• Roadmap
• How to connect to on-premise data
• Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, table, fail, nothing, show , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem