business Query

other Business Query
1

Any experts on BQ? I am wondering where the query is stored for these, is it local or in the repository?

Scott Bowers :us: (BOB member since 2002-09-30)

2

I’m not an expert but I do know where the queries are stored.

When you create a query in BQ, a .bqy file is created and stored in the folder specified in your File Locations for BusinessQuery Files. There are some sub-folders involved (universe domain and universe name).

The .bqy files are completely separate from the excel file. There is a ‘pack workbook’ function that allows you to save the queries with the excel file.

Say you don’t pack the workbook, and you’ve saved an excel file into which you’ve inserted queries (say that grammatically three times really fast). When you try to refresh the queries in that workbook, BQ will look in the current File Locations for the .bqy file and refresh the ones it finds. Interesting things happen here if you’re sharing excel files with others but forget to pack them.

KSG :us: (BOB member since 2002-07-17)

3

Thanks, that answered my ? I looked at the files there and found a folder “Universe” and under that was my mystery query.

What happened was that I was doing testing and in the insert query menu, there was a query listed there that I hadn’t created under the Universe name. So I wasn’t sure if it was looking in the repository as well as the file system. Now I know, thanks
Scott

Scott Bowers :us: (BOB member since 2002-09-30)

4

Just as an FYI…

Nothing that is “in use” can be stored in the repository. Items in the repository (documents, universes, etc.) are stored, not used. If you open a document from corporate documents via Webi, for example, you are first retrieving that document to the server (or your workstation via ZABO) and then opening the document. You can’t refresh a document in the repository. :wink:

Dave

Dave Rathbun :us: (BOB member since 2002-06-06)

5

Has anyone ever “disected” a packed BQ workbook and found where the bqy files are stored? I’ve gotten far enough to know they are “somewhere” on the hidden #BusinessQuery# worksheet, but I can’t find exactly where.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

6

I have never looked. Packed workbooks have their own challenges (weird things happen when you try to just refresh one query, for example). I don’t like them very much.

KSG :us: (BOB member since 2002-07-17)