3639646 - SAP.ASYMMETRICFILTER does not work with time-related calculated measures in SAP Analytics Cloud Excel Add-In

Data fails to populate when applying the SAP.ASYMMETRICFILTER function to a YTD/QTD/MTD measure in the SAP Analytics Cloud Excel Add-In.

SAP Analytics Cloud, add-in for Microsoft Office

1. Apply the SAP.ASYMMETRICFILTER function.
2. Observe that YTD measure does not show any data.

Time-related calculated measures, such as YTD, are not supported with the SAP.ASYMMETRICFILTER function due to a known technical limitation.

The issue is caused by the technical limitation of the SAP.ASYMMETRICFILTER function with time-related calculated measures.

Please kindly submit an improvement request as per: 

• 3079294 - Enhancement Request for SAP Analytics Cloud, add-in for Microsoft Office

• 3079294 - Enhancement Request for SAP Analytics Cloud, add-in for Microsoft Office
• Roadmap SAP Analytics Cloud Add-in for Microsoft Office

• Online help for SAP Analytics Cloud, add-in for Microsoft Office
• SAP Analytics Cloud, add-in for Microsoft Office community topic page
• 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 Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

sap.asymmetricfilter, ytd measure, sap analytics cloud, excel add-in, data not populating, time-related calculated measures, sap.block, hierarchy, filter, technical limitation, asymmetric function, cumulative performance data. , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem