SAP BW Bex Parameterizing and Filtering data on user id

SAP BW Bex Queries:

While using Bex Queries it is mentioned that the parameters once configured in a connection cannot be changed. Are there ways of parameterizing the required data from code using Ironpython scripts like we have parameterizing the information links? If we have configured the parameters to pick all the months, the amount of data would be huge and we don’t have ways of limiting the configured connections. How to

How can we pass the user id to the Bex Query so that we can get data based on the users access setup in the SAP BW? Is there a prompt feature to allow the user to enter the user id and password to pass to the connection so that the SAP knows which data has to be returned?

(1) Answer