SAP Knowledge Base Article - Public

3601573 - How to get a list of users that have logged in SAP Analytics Cloud in the past X number of months?

Symptom

  • Need a list of active users in SAP Analytics Cloud.
  • How to get a list of users that logged in SAP Analytics Cloud in the past few months?

Environment

  • SAP Analytics Cloud 2025.1

Resolution

  • To get a list of users that logged in SAP Analytics Cloud in the past few months, create a Story based on the Model: ACTIVITY_LOG:
       
    1. Share the ACTIVITY_LOG Model with the users:
      1. Login to SAP Analytics Cloud.
      2. Go to Files, and in the left pane, select: System
      3. Navigate to: Common / SAC Content / SAC Content Overview / SAC Content Overview - Models
      4. Click on the checkbox, on the left side of the Model: ACTIVITY_LOG
      5. In the toolbar, click on the "Share" icon, and select "Share..."
      6. In "Share Model", add the Users, or Teams you will like the Model to be shared with, and click "Close"
          
    2. Create a Story, based on the Model: ACTIVITY_LOG, and add a Table with the columns: Username, Date, and Activity Type
      1. Create a new Story
      2. Add a Table widget, based on the Model:  ACTIVITY_LOG
      3. In the Rows, add the Dimensions:
        • Username
        • Date
        • Activity Type
            
    3. Add a Filter on the Table on the Dimension: Activity Type, and filter on: Login
        
    4. Add a second Filter on the Table on the Dimension: Date, and filter on a Date Range of X number of months.
        
      The Table will display a list of users that have logged in SAP Analytics Cloud in the past couple of months.

Keywords

SAC, user list, active users , KBA , LOD-ANA-ADM , SAC Administration , How To

Product

SAP Analytics Cloud 1.0