nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Is there an option (GoURL) of Download to Excel/CSV Administration/Manage Sessions ?

User_Z8Y6M

Hi,

I'm a user of Sales Cloud OTBI.

There is no way to configure the regular for OBIEE Usage Tracking.

There is no API (web service) to apply to OTBI Sessions metadata.

I try the alternative way of creating a custom usage tracking by scheduling of export Administrator > Manage Sessions > Download (bottom) to excel and than to local DB table.

So, the question: is there an option (GoURL) of Administration > Manage Sessions > Download to Excel/CSV ?

Thanks,

Ark

Find more posts tagged with

Accepted answers

All comments

Robert Angel

Yes there is, see =>

https://docs.oracle.com/middleware/1221/biee/BIEIT/apiwebintegrate.htm#BIEIT353

Downloading data in Excel. This is related to the syntax shown above but replaces the dashboard path with a report path, and adds syntax to download the data in Excel2007 (data downloaded is for prompted values only).

Example:

saw.dll?Go&Path=%2fshared%2fSAT%20Regional%2fRegional%20Reports%20with%20guided%20navigation%2fRegion1_AMR&Action=Download&format=excel2007 &col1=%22Dim_Program_D%22.%22PROGRAM%22&val1=%22O_K5B%2B%22+%22O_K60B%22 &col2=%22Dim_Geo_D%22.%22COUNTRY_NAME%22&val2=%22Brazil%22+%22Canada%22+%22USA%22 &col3=%22Dim_Channel_D%22.%22CHANNEL%22&val3=%22RSLR%22 &col4=%22Dim_Geo_D%22.%22GEO%22&val4=%22AMR%22 &col5=%22Dim_PLAN_VERSION_D%22.%22Plan%20Version%22&val5=%22Current%20Plan%22

User_Z8Y6M

Hi Robert,

Thank you for your answers.

In general I confirm with GoURL technique.

But my question is more specific.

I need export to excel not from a member of Presentation Catalog such as Dashboard, Page, report etc.

I try to build url for export .../analytics/saw.dll?Sessions : goUrl replace of click on the bottom Download.

If you confirm with the possibility, can you type a url and check in your OBIEE if it can download administration > manage session > Cursor Cache to excel ?

Thanks,

Ark

[Deleted User]

No you can't

User_Z8Y6M

Thank you, Christian

Robert Angel

Sorry, assumed you had some custom report method on the manage sessions functionality and were just asking on GO_URL download...