Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
chrisg
Creator III
Creator III

Load ".BQY " ?

Hi,

is it possible to load data from Hyperion - i think the format is ".BQY"

many thx

Christoph

Do or Do Not. There is no try!
2 Replies
biester
Specialist
Specialist

Hi Christoph,

perhaps I'm totally wrong (actually I don't know anything about Hyperion) but as far as I have learned from a quick search, BQY-files do not contain data resp. a result of a SQL query but only the SQL query itself. So I don't think you can't directly access these files from QlikView but have to re-write the respective SQL-queries.

Rgds,
Joachim

Not applicable

Hi Christoph

The BQY content can be accessed using e.g. VB, but this is a long story and you have to traverse their object trees to access information.

Are you intersted in the report definitions or in included data? For the data it might be easier to copy the query over into a .qvw file and optionally create a fast loading qvd file from it.

I have experimented with reading out information from BQY's because I wanted to get a complete view of all tables and views in use in my project.

As this is not a QlikView issue you might want to address me directily for further questions or examples.

Regards

Juerg