- SAP Analytics Cloud not accepting "MMM.YYYY" or "MMM YYYY" when importing Year/ Fiscal Year / Period data from BW.
- The imported rows are identified as TIME, but highlighted in red color therefore the Data Integration phase cannot be finished.
- "Failed to convert <number of rows>" warning is being displayed, when using data transformation options to convert to Date. However, nothing happens when clicking on "Show errors".
- SAP Analytics Cloud 2018.2.2
- SAP Business Warehouse (Import Data Connection)
Reproducing the Issue
- Import query from BW having date format like "MMM YYYY".
- Observe that the imported rows are recognized as TIME Dimension but highlighted in red and not accepted by SAP Analytics Cloud.
This issue is resolved in version 2018.05.
- Edit the dates manually on the data integration page to "Mmm.YYYY" format.
- Run a Change to Titlecase transform to convert all of the values in the column. This will be applied during the scheduled refresh and should handle new values.
- Help resources and free SAP Analytics Cloud content
- Help portal
- SAP Community (Questions & Answers / Direct Link to ask question / Blogs)
- SAP Community WIKI
- Improvement requests (on the SAP Customer Influence portal)
- Video tutorials
- Videos by topic areas: (Overview, Models and Connections, Stories, SAP Digital Boardroom, Planning, Collaboration, Administration)
- Training events
- Past event recordings
- New user handbook
- How to connect to on-premise data
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud
HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, red, YYYY, PP, PPP, sparca, wrangling, SAP_BW, BW , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem