Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    8

    Unanswered: JDBC connection to MS OLAP database

    Hello all,

    Please may I have your assistance?
    I need to be able to connect(JDBC?) to my MS OLAP database from my Web based Java application. Can this be done? if so how.
    Your comments would be greatly appreciated

  2. #2
    Join Date
    Aug 2004
    Posts
    8
    Use the MS SQL Server provider for JDBC and write your query in T-SQL then call your MDX using the function OPENQUERY (example below). However I'm not sure if this would have a performance impact

    EXEC sp_addlinkedserver
    @server='olap_server',
    @srvproduct='',
    @provider='MSOLAP',

    @datasrc='serverName',
    @catalog='foodmart 2000'

    go

    SELECT * FROM OPENQUERY(olap_server,
    'SELECT
    { Time.Year.[1997] } ON COLUMNS,
    NON EMPTY Store.MEMBERS ON ROWS
    FROM Sales
    WHERE ( Product.[Product Category].[Dairy])' )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •