Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – IQY and Auto Generation of GO URL

Posted by Venkatakrishnan J on October 31, 2007

I would like to write today about two interesting but un-noticed features of Oracle BI EE. The first one is called as IQY or intelligent Web Query which will generate an export of the data in Excel that can be refreshed from within Excel. Of course, now that we have BI EE Office add-in this is available out of the box if you are on 10.1.3.3.0 or above. But for users who are on the lower versions, IQY is a very good feature which would basically help financial users to get the refreshed report data directly from and into Excel. In order to generate the IQY file, go to any report that you have created in Answers and then go to the Advanced tab of the report. There you would see 2 links. If you click on the second link it would basically ask you to save the report as an IQY file.

      

After saving this file open it in Excel. Lets try to understand what this IQY file actually does. After opening the file you would basically see that the report which you have exported would be available in Excel(it does not support charts). But what you would not notice is that this uses the Web Query feature of Excel. Go to Data->Get External Data menu in Excel. There click on Edit Query

      

There you would basically see a URL to the report. Here you can use GO URL or the URL generated by IQY.

      

As you see it is a very simple feature but again that can be used on a regular basis for refreshing your data. The next feature that i wanted to talk about is the GO URL Auto Generation. If you do not want to remember the GO URL formats then you have another feature in the advanced tab of a report wherein you can get the GO URL link for the report. The first link that you see in the Advanced tab is the GO URL link for that report. Pretty simple features but again generally not noticed.

Advertisements

One Response to “Oracle BI EE 10.1.3.3/2 – IQY and Auto Generation of GO URL”

  1. Rajesh said

    hi venkat,

    i have a requirement to pass a filter value from IQY file to get the filtered data. Is this possible in OBI EE 10.1.3.3.3.

    As the IQY file prompts for Username and password, is it possible to Prompt for a column value to filter the report?

    I searched through metalink and this feature is not available in SA 7.8.

    Thank You

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: