Click here to Skip to main content
15,888,351 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hello ,

I am interacting with the Brio Query file using VB.Net Code.For all those who are not very much familiar with Brio it is the .BQY file in the Hyperion Tool.

My Code is working fine on the server but when i use it on my local machine it gives an error.

Error :

Unable to cast COM object of type 'BrioQry.ApplicationClass' to interface type 'BrioQry._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{5D2B9A02-4F48-11D2-B1A6-00104B67DFD5}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

I have used the below code to create the object for the same.It gives me error at the code piece where the object is created.

Code :

Dim mybrioobj As New BrioQry.Application
Public mydoc As Object
mydoc = mybrioobj.Documents.Open(filename, "FileName") -- Error at this line

Any help is appreciated.

Regards
Himanshu
Posted
Comments
CHill60 28-May-13 6:15am    
Do you have the correct version of Hyperion installed on your local machine?
Himanshu__Bisht 28-May-13 10:53am    
Yes i have the same version installed as in the server.

Sergey Alexandrovich Kryukov 28-May-13 12:44pm    
It's so great to use abbreviations! From the first glance, it becomes clear that you need
Brio, toys, strollers, car seats and furniture for .NET:
http://www.brio.net/
:-)
—SA
Himanshu__Bisht 29-May-13 0:17am    
Thanks for this very useful tip..I will try and use the full forms going forward :-)

by BRIO here i mean the BQY files for the Oracle Hyperion Tool.
Sergey Alexandrovich Kryukov 29-May-13 0:36am    
You are very welcome, and thank you for clarification. I think your sense of humor is a big part of success... (sorry, I'm not familiar with the topic, otherwise I would certainly try to help you).
—SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900