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

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
42
Views
5
Comments
User_Z8Y6M
User_Z8Y6M Rank 3 - Community Apprentice

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

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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
    User_Z8Y6M Rank 3 - Community Apprentice

    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]
    [Deleted User] Rank 2 - Community Beginner

    No you can't

  • User_Z8Y6M
    User_Z8Y6M Rank 3 - Community Apprentice

    Thank you, Christian

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

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