SYMPTOM:
When running a prompted report against SAP users notice that the "find" box to filter/search for elements is grayed out.
CAUSE:
One potential cause of this is connection type of the database instance being used. For SAP BW datasources, there are different connection types such as SAP BW and SAP BW 7.x. The "Find" functionality within a prompt page is only available when using the SAP BW 7.x connection type.
ACTION:
Modify the database instance to use the "SAP BW 7.x" connection type. With this connection type being used the find functionality should work properly.
NOTE: An additional requirement for this feature can be found in KB45994: Introduction of the ability to search on an element prompt based off a MDX variable from SAP BW query cubes where the variable is optional.
