SAP Knowledge Base Article - Public

3563804 - The member selector of a specific filter cannot be opened in Data Analyzer and Optimized Story of the BW live connection in SAP Analytics Cloud (SAC)

Symptom

  • In the Data Analyzer and Optimized Story, the member selector of a specific filter cannot be opened.
  • This filter is automatically added when creating the Data Analyzer or the Optimized Story.
  • In the Optimized story, the filter shows as (Misc.).
  • In the Data Analyzer, the filter shows a popover with filtered members listed when clicking on the filter token. 
  • When the original filter is deleted and a new filter for the same dimension is added, the issue does not occur.
  • The issue happens as well if you create a new data analyzer or a new Optimized story for the same BW query.

Environment

SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Create a Data Analyzer from a BW query
  2. Try to open 1 filter that is automatically added
  3. It cannot be opened.

  1. Create an optimized story and add a table for an SAC BW live model.
  2. Check the automatically added table filter.
  3. Observe the filter shows with values (Misc.)
  4. Click this filter.
  5. The member selector cannot be opened.

Cause

It works as designed.

Data Analyzer

In Data Analyzer we do not support the editing of filters on a non-compound field of a compound dimension. For example, your dimension is a compound dimension and the filtered field is non-compound (PTAGPRFCT.KEY_NOT_COMPOUND).

You could also see this information if you were to go to the filter bar, click the "Add filter" button, and attempt to add a filter on the "Profit Center" dimension. A popup leads you to a SAC Online Help page - https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/90edb0e43311457a8d331d31c1129cb1.html - where you can see this information under topic "Adding Filters":

  • "There are cases when the filter of a compounded dimension defined in the SAP BW query is causing an incompatible filter state in data analyzer. This is the case, if the higher-level dimension of the compounded dimension is not filtered uniquely. This scenario cannot be mapped to the dimension filter dialog, hence you are asked to first remove the current backend filter to be able to open the filter dialog."

In terms of how it is presented now in Data Analyzer, it is a textual list of filters, each with a "between" operator. This is to give some context to what is being filtered, even though editing is unsuppported.

Story

In the story, it is designed to show a non-editable filter token with subtext (Misc.) in certain conditions. One of these conditions is that a "between" comparison operator is used in a filter for some dimensions. Thus, here you also cannot edit it.

Resolution

We are thinking about how we better present this information in the data analyzer in the future to be consistent with the optimized story. 

See Also

Keywords

Data Analyzer, Optimized Story, Table Filter, Profit Center, SAC Model, Member Selector, Filter Values, 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-DAN , SAC Data Analyzer , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions