Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Is there an option (GoURL) of Download to Excel/CSV Administration/Manage Sessions ?
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
Answers
-
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
0 -
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
0 -
No you can't
0 -
Thank you, Christian
0 -
Sorry, assumed you had some custom report method on the manage sessions functionality and were just asking on GO_URL download...
0