SAP Knowledge Base Article - Public

2644375 - The result of SAPGetDimensionEffectiveFilter does not consider the sort of the dimension

Symptom

The result of SAPGetDimensionEffectiveFilter does not consider the sort of the dimension. For example, the dimension is sorted as Descending, but the result of SAPGetDimensionEffectiveFilter is sorted as Ascending.

71.jpg

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP BusinessObjects Analysis for Microsoft Office 2.5
  • SAP Analysis for Microsoft Office 2.6
  • SBOP ANALYSIS MS OFFICE 2.7

Reproducing the Issue

Use formula SAPGetDimensionEffectiveFilter in a cell in AO.

Cause

This is the current system behaviour. SAPGetDimensionEffectiveFilter uses an algorithm to create the effective selection. This algorithm does not consider the sort of the dimension.

Resolution

This behaviour cannot be changed.

Keywords

sorting, limitation, AO, Analysis for Excel, Analysis for Office, A4O, Resultset, ignore , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office 2.6 ; SAP Analysis for Microsoft Office 2.7 ; SAP BusinessObjects Analysis for Microsoft Office 2.5