| David Browne 2006-04-02, 8:23 pm |
|
"SQL Server - Novice" <SQL Server - Novice@discussions.microsoft.com> wrote
in message news:AE1D7040-346D-46E9-8B74- B1D63BDE277B@microso
ft.com...
> Can JDBC be used for retrieve data from OLAP Cube ?
> or retrieve data from database only ?
>
Yes, but only if the Analysis Services instance is set up as a linked
server.
Using a linked server SQL Server can route queries to heterogenous back-end
systems. One of the systems it supports is SQL Server Analysis Services.
You would end up sending a query like
SELECT a.* FROM OpenRowset('MSOLAP',
'DATASOURCE=myOlapSe
rver; Initial
Catalog=FoodMart;',
'SELECT
{ Time.Year.[1997] } ON COLUMNS,
NON EMPTY Store.MEMBERS ON ROWS
FROM Sales
WHERE ( Product.[Product Category].[Dairy] )') as a
See
How to perform a SQL Server distributed query with OLAP Server
http://support.microsoft.com/defaul...kb;en-us;218592
For details.
David
|