3552527 - SAP Analytics Cloud support for SAP Datasphere dimensions with compound keys

In SAP Analytics Cloud (SAC), the Datasphere live connection is in use. Some issues are observed. For example, 

• The table in your story has both "Profit Center" ("PROFITCENTER∞D0") and "Profit center" ("ZPROFITCENTER∞0") appearing in the table widget, while only "Profit center" ("ZPROFITCENTER∞0") shows up in the table builder panel. 
• This issue is specific to the existing tables and is not reproducible in a newly created table.
• When trying to remove the Profit Center dimension, an error message is displayed and the dimension is not removed: "The query is inconsistent: Following compound key column(s): '[CONTROLLINGAREA∞D0]' must be defined either in Dimensions or in Filter in order to make a consistent."

SAP Analytics Cloud

1. In the table, notice that the first 2 columns are Profit Center. However, in the builder, there is only 1 Profit Center.

Prior to the SAP Analytics Cloud (SAC) 2024 Q3 QRC release there were a number of workflows which did not correctly handle dimensions with compound keys defined in SAP Datasphere (i.e. these workflows were not blocked but would result in avoidable error states):
- Key columns were exposed as navigational attributes in Stories even though they should not be.
  - When key columns were used in queries it resulted in "query inconsistent" errors like the one you are observing, unless all key columns were somehow included in the query context.
- Compound dimension keys only supported exact matches ("=" comparisons), and as a consequence:
  - Searching on a partial key values would fail with a server error.
  - Any exclude filters defined on compound dimension keys would cause a query to fail.
  - Range/Condition filtering is not supported on a compound dimension key and would cause a query to fail.
- Compound dimension keys could not be used in certain advanced features:
  - Calculated Dimensions
  - Certain Filtering Across Models (FAM) workflows
  - Histogram charts
  
Starting with the SAC 2024 Q3 QRC release Optimized Story behaviour was changed to:
- Update query generation to enable supportable workflows. This included enabling compound dimension usage in:
  - Calculated Dimensions
  - Filtering Across Models (FAM) workflows
  - Histogram charts
- Block unsupported workflows by hiding key column attributes from the list of available navigational attributes in widget builder panels as well as in filter creation workflows.
  - Story content created prior to the SAC 2024 Q3 QRC release will continue to display as it did when it was created, but edit workflows will be limited:
    - The dimension listing dropdowns in widgets (e.g. charts, tables, filters, etc.) will no longer show key column attributes.
    - The chart builder panel will still show any key column attribute's dimension token in the corresponding feed (e.g. "Dimensions"), but once removed it can no longer be added.
    - The table builder panel will no longer show any key column attribute's dimension token in the "Rows" or "Columns" feed.
      - If a key column attribute needs to be removed from a table displaying it the best option is to recreate the table.
  - If the key columns are needed as independently selectable attributes one option is to create additional attributes (as a copy of the originals) and expose them as navigational attributes which are not part of the compound key.
 
Starting with the SAC 2024 Q4 QRC release Optimized Stories also adopted a server enhancement to support searching compound dimension keys on partial key values (i.e. using "LIKE" rather than just "=" comparisons).
 
Note: Unlike Optimized Stories, Data Analyzer does not currently hide key column attributes.

- If a compound key column attribute (e.g. "Profit Center" ("PROFITCENTER∞D0")) needs to be removed from a table displaying it the best option is to recreate the table.
- If compound key columns are needed as independently selectable attributes one option is to create additional attributes (as a copy of the originals) and expose them as navigational attributes which are not part of the compound key. 

SAP Analytics Cloud, Builder Panel, Table issue, Invisible dimension, Reproduce issue, Condition tab, Error message, Processing of message &1 stopped, Query inconsistent, CONTROLLINGAREA∞D0, ZPROFITCENTER∞0, 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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, 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, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, dashboard , KBA , LOD-ANA-DES-SMQ , SAP Analytics Cloud Story Metadata and Queries , LOD-ANA-TAB , Table , Problem