3045406 - "Filter by measure" is grayed out or not appearing when using a HANA datasource in Analysis Office

Whenever using a HANA datasource (with a HANA view, for example) in Analysis for Office, if we try to apply a "Filter by Measure" on a measure, the option for "Filter by Measure" is grayed out or is not even coming up for the same, as per screen shot below:

Here is the same scenario when using a query in BW, where we can find the option to "Filter by Measure" on a measure and which was required with a HANA datasource:

• SAP Analysis for Microsoft Office All versions

filter by measure, HANA, BW, datasource, how to, filter, guide, top N, bottom N , KBA , BI-RA-AO-XLA , Excel Addin , Problem