I have a stored procedure that accepts start and end date as parameters.
In my VSS project, I selected "Import From Data Source"
Select Microsoft SQL Server
Selected "Write a query that will specify the data to import"
Click on the Design button and select the stored procedure
When you select the procedure, it asks you to enter values for start and end date.
I enter the start and end date values and click the Finish button
What I want to know is when I publish this, it will send the current data set to SSAS. Is it possible to prompt the user to enter the start date time when they try to select the published data.