Skip to Content
0
Former Member
Jul 02, 2010 at 03:26 PM

Just getting started, can you point me in the right direction?

20 Views

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.

Thanks.

Matthew