SAP Knowledge Base Article - Public

3367697 - No member displayed to select in Filter in Query Panel in SAC Stories

Symptom

  • No members are displayed in Filters("Set Filters for....") when adding a new dimension from Query Panel in a story in SAP Analytics Cloud.
  • No error is generated. 
  • Using live connection to BW. The data source is a CDQ query. 

Environment

  • SAP Analytics Cloud (Enterprise)
  • SAP Business Warehouse 757 0001

Reproducing the Issue

  1. Add a new dimension in Query Panel. 
  2. Try to set a filter for the added dimension by selecting Filters button in Query Panel. 
  3. No member displayed in the prompt window "Set Filters for [Dimension Name]"

Cause

The CDQ query does not show the members when it is directly executed in tcode RSRT in BW.  Any other frontend will present the same behavior.

Resolution

Apply NOTE 3291900 - No data when calling value help for CDS-based queries, to resolve issue in BW first. Then confirm the result in Query Panel in SAC. 

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, 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.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://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, incident, ticket, OSS , KBA , LOD-ANA-TAB , Table , LOD-ANA-PL , Planning , BW-BEX-OT-F4 , MasterData read services , Problem

Product

SAP Analytics Cloud 1.0