Post reply

using a datasource to connect to a OLAP database/cube

  • February 17, 2009 at 8:41 pm

    #200283

    Hi FOlks,

    I don't know too much about OLAP. Can you use a datasource (ODBC, .NET connection string) to connect to a OLAP database or cube?

  • February 17, 2009 at 9:38 pm

    #945652

    I have tried this in .NET

    Dim ConnectionString As String = "Provider=MSOLAP.3; Data Source=localhost;Initial Catalog=OLAPDB;Integrated Security=SSPI"

    MDX

    -----

    Dim SelectQuery As String = "Select NON EMPTY [Dim Product].[Name].Members ON Columns,NON EMPTY [Dim Executives].[Hierarchy].[Territory] on Rows From [TESTCUBE] "

  • February 18, 2009 at 4:35 am

    #945781

    If you are looking for any type of help with creating connection strings then you should take a look at - http://connectionstrings.com/[/url]. With OLAP you have .NET, OLEDB, and ADOMD.NET.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply