SAP Knowledge Base Article - Public

2859695 - Failed to create model with error "Column <...> can't be included in leveled hierarchy <...>" after adding a level-based hierarchy during the data-preparation stage in SAP Analytics Cloud (SAC)

Symptom

  • Failed to create model with error "Column <...> can't be included in leveled hierarchy <...>" after adding a level-based hierarchy during the data-preparation stage in SAP Analytics Cloud (SAC)  
  • Error detail:
    "Model <...> creation has failed. Please try again.  Error detail:  {"targetPerspective":"<...>","perspectiveType":"Generic","error":"Column <...> can't be included in leveled hierarchy <...> ","stack":"DimensionManager.prototype.create@/sap/fpa/services/modeling/dimension/DimensionManager.xsjslib:577\nDimension.prototype.setData@/sap/fpa/services/modeling/frameworkPlugins/Dimension.xsjslib:67\ncreateObjectEx@/sap/fpa/services/bo/EpmObjectManager.xsjslib:621\nDataIntegrationObject.prototype.createObjectEx@/sap/fpa/services/dm/DataIntegrationObject.xsjslib:103\nDataSourceService.prototype.createGenericDimension@/sap/fpa/services/dm/excel/DataSourceService.xsjslib:3492\nDataSourceService.prototype.createDimension@/sap/fpa/services/dm/excel/DataSourceService.xsjslib:174\nDmMediator.prototype.createDimensionScheduled@/sap/fpa/services/dm/excel/DmMediator.xsjslib:4763\ndoAction@/sap/fpa/services/dm/DataIntegrationScheduleManager.xsjslib:75\nrun@/sap/fpa/services/job/Schedule.xsjs:116\n","sFileId":"f641f4ff43754b06a03b52074a307278"}."

Environment

  • SAP Analytics Cloud 2019.15.15

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Import the problematic excel file to create a new model.
  3. In Data Integration view, select Level Based Hierarchy from tool bar.
  4. In the Hierarchy Builder, type a name for the hierarchy.
  5. Select columns to build the hierarchy.
  6. Keep option Generate a 100% unique bottom level for my hierarchy checked and then click OK.
  7. Click Validate Data button.
    => Validation completed without any issue.
  8. Click Create Model button and then save the model.
    => Failed to create model with error "Column <...> can't be included in leveled hierarchy <...>".

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

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, import, model, data, prepare, preparation, level, level-based, hierarchy, LBH , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0