mchokshi 71349 (3/26/2015)

---

I am working on SSAS model and need to create a Powerpivot based on it. I am using Analysis Services Tabular Project in Microsoft Visual Studion. the sql My question is how to create a model based on the query with variables? For example my Sample query is as follows:

Any suggestion is welcome.

Select Name,Supervisor,Organziation,SUM(HOURS),SUM(PAY)

from extratime

where organization=@orgname

and start_date >=@st_dt and start_date<=@end_dt

group by Name,Supervisor,organization

order by name