January 3, 2023 at 9:52 pm
I am trying to get data from a stored procedure into my SSAS Tabular model project. This stored procedure accepts few parameters. Is there away to supply the parameters at run time without hard coding it?
January 4, 2023 at 3:39 pm
Could you please tell us a little bit more about your setup?
😎
There are many ways of doing this, each of which is applicable in certain circumstances. Not knowing those will leave everyone guessing.
January 4, 2023 at 7:39 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply