Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Named Searches - Performance Questions

Dear MDM Pros,

I have question regarding the performance of Named Searches.

I have a repository with 600.000 datasets (and various lookup tables) now I need to setup named searches for restricting the access to the data.

I have one field with classifications (Number 8 digits / 15.000 different classes) on that I want to restrict access. The restriction should work on the first 2 digits of a class.

Example Classification:

21010509

21010503

21010504

21010507

19050711

19050912

31020530

Rule:

LEFT(CLASSIFICATION,2) >= 19 AND LEFT(CLASSIFICATION,2) <= 21

So my idea is to use this

LEFT(CLASSIFICATION,2) >= 19 AND LEFT(CLASSIFICATION,2) <= 21

Expression in the search and save this as Named Search.

As wrote before I think this is really slow.

Can anybody give me a hint how to find a performance optimized solution for this problem.

Best regards

Roman

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question