Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
is it possible to load data from Hyperion - i think the format is ".BQY"
many thx
Christoph
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
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