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

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?