embedding Olap connction information in a OWC Pivot table htm

[Eric S]

I'm trying to figure out how I can deploy a "published" pivot
table/chart with a remote olap connection. From what i'm seeing the
document doesn't put the connection variables for the OLAP connection
into the .htm page..

or does it and i am just missing it.

I'd like to use exported "interactive" page to distribute with the
connection infomation in it. I've gotten the following error when i try
to open it on a different computer.

"The query could not be processed:
Safety settings on this machine prohibit accessing a data source on
another domain".

Both of these systems are one the same domain, but the SQL analysis
server is located on the one i created the OWC page with. the other
simply cannot use the connection it's "supposed" to.

So my question is...

Do i need to distribute the ".oqy" connection file with the document,
or is there a way to include it in the file?

-Eric

 

[Eric S]

oops... ok i found the connection information in the recoded XML
source in the .htm file...

But doesn anyone know why i'm getting the

"The query could not be processed:
Safety settings on this machine prohibit accessing a data source on
another domain".

Error?

 

[Alvin Bruney [MVP]]

Because of security restrictions you won't be able to access data from
another domain unless you specifically add the domain as a trusted source in
internet explorer security settings.

hope this helps

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc