Access to download .iqy file in Oracle BI Interactive Dashboards

Dulce Bautista

(Please let me know if I should be posting in another forum.)

When trying to download the .iqy file for a Dashboard, it says that I am not authorized.  Is there a way to grant this access?

STEPS TO REPRODUCE:

1. Log into Oracle Business Intelligence.
2. On Home Page-->Recent, select Edit for one of the dashboards.
3. Select Advanced tab.
4. In the Referencing the Results section, select the 2nd link to download the iqy Web Query file.
5. 
6. When prompted, save the file locally and attempt to open it.
7. When opening, it launches Microsoft Excel along with a message "Microsoft Office has identified a potential security concern.  Data Connections have been blocked. If you choose to enable data connections, your computer may no longer be secure.  Do not enable this content unless you trust the source of this file."
8. 
9. Select the Enable button.
10. Enter login information at the prompt for Oracle BI User.
11. The spreadsheet then displays with the following information:  "You are not currently authorized to use Oracle BI Interactive Dashboards.If you would like to use this powerful capability, please contact this site's administrator."

[Deleted User]

Morning Dulce,

So this functionality is kind of a "leftover" of older days and for example doesn't exist anymore in 12c on-premises or OAC - it was actually explicitly removed in 11.1.1.9 already! Reason being two fold:

a) the tool of choice for Office integration is SmartView since a while now and they are getting rid of "alternative ways" since they are just deprecated

b) security:

The call behind such an iqy file is basically nothing but an OBIPS URL "Download" call with Format=excel&Extension=.xls&BypassCache=true&PathEncode=IQYEncode&Path=123abc&NQUser=...&NQPassword&SyncOperation=1

...a bit restrictive and "meh" ;-)

Still you CAN use this in old versions but the user you're connecting to the server as has to have the proper privileges set. What kind of application roles does the user you're trying to connect as have? Some vanilla ones or purely custom roles?

If you want to generally test - use an admin and it'll prove the concept works. But in all honesty I'd seriously suggest using SmartView since IQY will just go away as soon as you upgrade to a current version.

Dulce Bautista

Hi Christian,

I logged in using our Admin id and I experience the same error.  My Admin id is a member of the following groups:  Administrators, BIAdministrators.  Is there another access right that I may need to include?

Regards,

Dulce Bautista

Sherry George

Does the environment use single sign on?

[Deleted User]

Hah too late. Yeah the functionality needs an explicit login with username / password and does not support SSO

[Deleted User]

As long as you have access to the Advanced Tab the ability is available to you: Creating Analyses - 11g Release 1 (11.1.1)

But as Sherry pointed out you might be hitting the SSO wall.

Dulce Bautista

They are using explicit signon.  I attempted to add every possible group membership to the Admin user id and still no luck.

Is there anything else that I could modify to grant access to extract the file?

[Deleted User]

Let me re-state one of my initial questions: What kind of application roles does the user you're trying to connect as have? Some vanilla ones or purely custom roles?

Vanilla BIAdministrator must be able to do it.

Dulce Bautista

I am using vanilla ones.  I am using our administrator login that has the group memberships of Administrators and BIAdministrators.

[Deleted User]

Ok that's weird and definitely shouldn't be. Can you try and explicitly grant the Privilege "Access to Dashboards" to the BIAdministrator application role (rather than through inheritance)?

Dulce Bautista

Thank you for the reply.  Would you be able to provide the info on how to go about explicitly granting the "Access to Dashboards" to BIAdministrator?