Thursday, February 1, 2018

Mass filtering in AfO - not equal to

There is a function in AfO (called as SAP BusinessObjects Analysis or SBOP ANALYSIS MS OFFICE) tool available to make entering multiple values for filtering easy and convenient. In case there are many of values to be filtered out it is not very convenient way to go by each and every value to select it in a list of all members. Instead user may have all the values already prepared either in clipboard or in separate text file. This can be described as putting mass values into the filter.
AfO offers in dialog box of “Filter by Members” function a possibility to paste the filter values from the clipboard or paste it from file.

In case values for the filters are supposed to be set as “not equal to” the values in the filter selections shall be entered with exclamation mark (!) in front of the value: e.g. !xxxxx

However pasting value like that either from the clipboard or from the file doesn’t work. There is an error displayed: iString parameter is null

Even this issue is not listed SAP’s wiki page of Known issues with Analysis Office there is supposed to be a fix provided in SAP Note: 2452938 - Selecting a date value raises a warning message.


No comments: