dbTalk Databases Forums  

How to specify the cube in the connection string

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How to specify the cube in the connection string in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
karenmiddleol@yahoo.com
 
Posts: n/a

Default How to specify the cube in the connection string - 10-21-2005 , 11:05 PM






I am building a OWC application and as part of the connection string I
want to specify the cube name.

But I can't find any documentation on specifying the cube name in the
connection string as follows:

"DATA SOURCE=MYServ;PROVIDER= msolap;INITIAL CATALOG=DB;CUBE =
cubename;"


Please help.

Thanks
Karen


Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: How to specify the cube in the connection string - 10-22-2005 , 01:25 AM






That is because it isn't in the connection string.
It is in the FROM clause of the MDX statement.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<karenmiddleol (AT) yahoo (DOT) com> wrote

Quote:
I am building a OWC application and as part of the connection string I
want to specify the cube name.

But I can't find any documentation on specifying the cube name in the
connection string as follows:

"DATA SOURCE=MYServ;PROVIDER= msolap;INITIAL CATALOG=DB;CUBE =
cubename;"


Please help.

Thanks
Karen




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.