Re: Filter using Passthrough SQL

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Create a view and then load AS from it rather than the original table.
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

<pj4u_73@xxxxxxxxxxx> wrote in message
news:1112718089.169288.147220@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> We have an application that issues passthrough SQL queries to an OLAP
> cube via a Linked Server. How can we specify a range of data in the SQL
> criteria(WHERE Clause) passed to the Cube? Ideally I would like to use
> the greater than and less than operators for a date range.
>
> Thanks
> Ryan
>


.

Relevant Pages