If anyone knows of a SAP document that covers this scenario, please drop a link into the thread:
Here's what I want to do:
Create about 10 dashboards that are hooked up to stored procedures in SQL Server. The data that comes back will be different depending upon the user running the procedure, so I I need to be able to pass in the user name (A BO variable name perhaps?), as well as a cut-off date.
If I can have a way to prompt the user for a cutoff_date, that would be perfect, but I obviously don't want to have to prompt them for their user_id as they could type in the name of a competing salesman and see his standings.
My initial plan was to write the procedures, add a QaaWS connection, and then design the dashboards, but the whole parameter thing stumps me. If it has to be a location in the spreadsheet, even though I'm using QaaWS, then I don't know how I can change it on the fly.
If you can help, let me know, I'm sure this has come up before for other people.