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

Create a view and then load AS from it rather than the original table.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
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 (AT) hotmail (DOT) com> wrote

Sounds interesting - in the view what would you put int he where clause ? A
variable ?


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Yes and No. You might have a control table which represents your date range:

create table my-control (begin-date datetime, end-date datetime)

insert into my-control values ('1/1/2004', '1/1/2005')

create view load-as as
SELECT t.* from <linktable> t
WHERE t.date between (select begin-date from my-control) AND
(select end-date from my-control)

then load Analysis Services from the view "load-as" -- no parameters are
needed.
Just update your control table when you want a different window from the
linked server.

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote