Range and wildcard use in Filter

[kljf_wiee]

Hi

The environment is SAPIBP2011. We have product ID's like A0001, A0002 ... A1000 and in in a planning filter range A0100-A0200 is expected. How can I put a range like this in both Planning Filter App and Excel add-in Filter? I can see only 'equal to' and 'not equal to' available. Furthermore, how to use wildcards to facilitate the selections? For example how to filter out products like A*00? Thank you in advance for any inputs.

klif

[neeraj_deshkar1 · Accepted solution]

Nope... range selection option is also not available as of now.

--Neeraj

[vincentverheyen]

See also question Dates (hardcoded as attributes): easiest attribute-based filtering in Fiori | SAP Community

I hope filtering capabilities for attributes can be expanded. I have submitted an Improvement Request for SAP IBP here: Filtering (currently only = or ≠) in Attribute-Based Filtering / Planning Filters (ranges, ≥, ...)

Please upvote the improvement request if you find this valuable.

[neeraj_deshkar1]

Hello,

I don't think wildcards can be used in IBP. However if you type A0... all products containing A0 would show up & you can select them all at once. We cannot save the filter by putting just A0...

Alternatively look for some common attribute these products have... Create one if it's not available. Then you would be able to save filter for this attribute & all the products corresponding to this attribute would be selected.

-- Neeraj

[kljf_wiee]

Thank you Neeraj. What about selecting a Range? Is that possible?