March 26, 2015 at 7:30 pm
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
March 30, 2015 at 8:54 am
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
A tabular cube does not accept variables. Include all organizations and dates in your model...the end user will be able to create filters themselves in Power View.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply