dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Add a New Data Source to Olap Cube - data.oledb.olap

This is a discussion on Add a New Data Source to Olap Cube - data.oledb.olap ; Hi - I'm not sure this is the proper place to ask this question, but I have not received any responses in the C# or VSTO forum. I'm developing a VSTO application (C#, Office 2007, Excel 2007 Template/Workook) that will ...


Home > Database Forum > Data Warehousing > data.oledb.olap > Add a New Data Source to Olap Cube

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 05-14-2008, 08:51 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Add a New Data Source to Olap Cube

Hi -

I'm not sure this is the proper place to ask this question, but I have not
received any responses in the C# or VSTO forum.

I'm developing a VSTO application (C#, Office 2007, Excel 2007
Template/Workook) that will reference a OLAP Cube located on an Microsoft
Analysis Server.

I'd like to "Add New Data Source" for the cube, similar to
the way one would access a table in a SQL Server Database. Is it possible to
do this? If so then what are the steps need to do this?

The alternative is to add the Connection using the Excel Ribbon
(Data -> Connections -> Add ...) thru the excel workbook designer which
works, but I'd like to know if I can do it through the Add New Data Source
wizard.

Thank you,
Mark
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 01:35 PM.