SAP Knowledge Base Article - Public

3232979 - Drill option is disabled for hierarchical dimensions in a story in SAP Analytics Cloud (SAC)

Symptom

In a story of SAP Analytics Cloud, the "Drill" option is greyed out for the specific dimension when right clicking on the dimension which has enabled hierarchies in the model

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Create a model containing dimension A
  2. Enable and create at least one hierarchy for the dimension A in this model
  3. Create a story based on this model and add a table containing dimension A to this story
  4. Right click on the dimension A header cell 
  5. Observe that the "Drill" option for this dimension A is greyed out

 

Cause

For performance reasons, after a system upgrade, models are upgraded consecutively over time. The function Redeploy Model can be used if there is any incorrect data or exceptions errors in widgets in stories and analytic applications. This usually means that the model is corrupted. This option can help to regenerate all runtime artefacts and fixes these errors.

Resolution

  1. Open the model and go to Model Preferences.
  2. Go to Data and Performance.
  3. Click on Redeploy Model.

See Also

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, sap analyst cloud, connected, failure, stopped, sap analyst cloud , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0