IQY - Web Query


NOTE : This feature is NOT working in OBIEE 11.1.1.6. A bug has been registered.
Bug 14040587 - OBIEE 11.1.1.6: OPENING WEB QUERY (.IQY) FILE IN EXCEL SHOWS JUNK CHARACTERS. 

Create a simple report . Save it as R1













 Open the Advanced tab









Click on the link that generates the web query(.iqy). Save it. This actually saves it in Excel format.












Open the R1.iqy ; It will prompt you to enter your OBIEE11g Userid and password.










































Let us go to OBI report R1 and modify it.












And now open the R1.iqy












The R1.iqy gets updated as well.

Have a nice day !!!






3 comments:

Rhishikesh said...

Nice post...

Nachiket Mehendale said...

Dhanyavaad !!

Titan said...

How can I implement this auto-refresh in Excel in csv format? The default format is Excel, but that format combines several cells together. I am looking for independent rows in the output file.