How do I create and save .odc and .oqy files in excel?

R

Ravindra Joshi

I need to create a OLAP data source connection pointing to Analysis Services
in a server present in different domain. I want to provide Username and
Password required to connect to this server also in this data source
connection; How do I define it and save it? Which one is preferred? .odc or
..oqy? How do I save them in the folder I want?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODC properties: OLAP Server Formatting 0
How do I save an OLAP connection to distribute with an Excel sheet 0
Dates In Excel 5
Create a chart from a table in word thats dynamic 0
open OQY file from http:// folder 1
how to make Excel linked to SQL Server 2005 worksheet editable? 0
How to create absolue path link to another workbook (Excel 2003) 1
.odc connection managing with vba in excel 2003? 3

Top