Forum Discussion

cap08's avatar
cap08
Contributor
3 days ago

Excel Add-in and Task Activity Log

Hello, 

I'm responding to audit requests regarding user task activities and found an active user which has no task activity logged. The user uses the Excel Add-in. What Excel activities are/aren't recorded on the Task Activity log? Is there a way to capture the Excel activities? 

Thanks! 

1 Reply

  • PatL's avatar
    PatL
    Icon for OneStream Employee rankOneStream Employee

    Hey cap08, have you seen the Task Activity Type filter list? This shows a few different Excel task types, such as Get Excel Data, Export Cube View to Excel, and Quick View. 

    The Design & Reference Guide has a Task Activity In Excel section, which suggests that Task Activity in Excel is stored in the same log table, which can be found under the System tab. 

    You can cancel a long-running cube view in Excel Add-In. You do not have to be logged into the Windows application. The Task Activity in Excel Add-In allows you to cancel your task. If you are an Administrator, you can cancel another user's running task. You can access the Task Activity icon in the Excel Add-In in the Tasks section in the OneStream ribbon.

    Importantly, you and your team may find Logon activity and other Audit data more suitable. 

    From the System tab, visit the Logon Activity page and filter for the Client Module: Excel

     

    From our Solution Exchangedownload the Navigation Center (ONC) solution. ONC is a new pack of various helpful audit reports. 

    You may also submit a new Support case, and the team will route your case to the appropriate resource for additional help!