This will give access to the Reports saved in My or shared Folders:
To work with the established connection, it is posssible to directly drag content of a pre-built analysis to Excel or to Load the element of the Analysis into Designer View to edit the Analysis before dragging it into Excel. The Designer View can be opened from the bottom of the Panel:
Ideally the BI Administration Tool should be able to use the TNS Identifier (SID) to connect to the Oracle Database. E.g. with the default ORCL
However, sometimes (probably because of Environment Variable settings) t he BI Admin Tool doesn’t Accept the Oracle TNS Identifier (SID). To have a quick workaround it is also possible to paste the complete TNS Entry into the BI Administration Tool. This allows the BI Tool to make the proper connection to the Oracle Database.
Data source name: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=orcl)))