SAP Knowledge Base Article - Public

3127121 - Error "Calculation couldn't be applied, attached member isn't visible in the grid" in SAP Analytics Cloud (SAC)

Symptom

After designing a story based on a live Hana connection which contains a table, formulas in the table are removed when the variables for the query are changed.  Mousing over the formula in the designer tab on the right shows the error "Calculation couldn't be applied, attached member isn't visible in the grid"

e.g.

You design a table that displays data for the year 2020, and has entries for Q1, Q2, Q3 and Q4 and a formula calculating the total at the end.  The formula was created by adding a column and entering a1 + b1 +c1 + d1 in the formula bar.  You then change the variable to return data for 2019.  The total formula is now removed and if you look at it in the designer tab it shows the error "Calculation couldn't be applied, attached member isn't visible in the grid"

Environment

  • SAP Analytics Cloud (Enterprise) 2021.20.10

Reproducing the Issue

  1. Create story based on Live Hana connection
  2. Add a table
  3. Add a formula
  4. Change the variable values for the initial query
  5. Note that the formula has been removed from the table.

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

Product

SAP Analytics Cloud 1.0