Utilizing our Sales and Billing HANA view, bringing in the measures that utilize a count function on the HANA view creates data differences for the 2 versions of Analysis for Office – Excel
Version 1.4 – Accurate numbers for count measures such as CountSalesOrderDocs and CountofSalesDocLines. Utilizes a relational database connection with this version.
Version 2.3 – Both the counts are adjusted incorrectly to varying degree (Lines count difference most likely due to slight difference in timing of data pulls). Utilizes an HTTP connection.
I am wondering if anyone else has noticed similar issues and found a resolution/work around.