Symptom
- No data returned when filtering for a specific date while creating a new Dataset based on SAP BW import data connection in SAP Analytics Cloud.
- Filtering for the same date returns back data correctly in RSRT.
Environment
- SAP Analytics Cloud 2021.9.2
Reproducing the Issue
- Create an import data connection to SAP BW in SAP Analytics Cloud.
- Create a new Dataset using the previously created connection.
- Try to set prompt for Fiscal Year / Period.
- Enter manually the selected specific values.
- Observe the Datasets come back empty.
Cause
- The Cloud Agent uses the value help of characteristics for validation of variable input.
- For regular characteristics, the values are maintained in the master data table. For time characteristics, the values are generated typically a few years into the past and in the future.
- However, the time interval for the value help can also be defined manually in transaction RSRHIERARCHYVIRT and will be persisted in table RSADMINS.
- The entered value is basically outside of the range which is maintained for the Hierarchy characteristic.
Resolution
- Updating the Time Characteristics to include the current years should resolve the issue.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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-AQU , Import Data Connections (Acquiring Data) , Problem