Xcelsius 2008, sp2. BOE 3.1 environment
I am trying to use the Opendoc function to open a Webi doc in Excel format.
The white papers say that the following formats are possible:
(H is default, if not specified)
&sOutputFormat=
H (HTML)
P (PDF)
E (Excel)
W (Word)
I have tried both of the possibilities below. The link opens the correct document, but the doc opens in PDF, not Excel 
http://myserver:0000/OpenDocument/opendoc/openDocument.jsp?iDocID=AXuqhT890r5CuamkQr7MLgs&sIDType=CUID&sType=wid&sOutputFormat=E
http://myserver:0000/OpenDocument/opendoc/openDocument.jsp?sPath=[Service+Center],[Dashboard+Prototypes]&sDocName=medicaid_dollars&sOutputFormat=E
If I remove the &sOutputFormat parameter from either link, the Webi docs open in HTML as expected.
Anyone know what I am missing?
EDIT: Whoops. I didnt do enough research. I discovered that you cant covert a Webi doc to Excel with OpenDoc…you can only convert a Crystal Report to Excel. For reference, the following link works and will convert the doc to Excel, if there is a .rpt file named medicaid_dollars in the specified folder.
http://myserver:0000/OpenDocument/opendoc/openDocument.jsp?sPath=[Service+Center],[Dashboard+Prototypes]&sDocName=medicaid_dollars&sOutputFormat=E
Cairmor 
(BOB member since 2008-06-05)