Symptom
You are reporting on User Logon activity and verify that field Logoff Date has Not Assigned/Hashtag (#) values in one or more rows, while Logon Date has values in every row.
Environment
SAP Cloud for Customer
Reproducing the Issue
-
Log into the system.
- Go to Business Analytics > Design Reports.
- Search and open the report User Logon Activity.
- Start the report.
- There are Not Assigned/Hashtag entries in one or more rows for field Logoff Date.
Cause
The # character visible in the report User Logon Activity for characteristic Logoff Date indicates the Not assigned entries, which occur when there are no records registered for Logoff Date but there are entries for Logon Date.
In other words, there are more than one register for Logon than Logoff registers in the system.
Resolution
This is the system expected behavior. You may want to filter the not assigned entries out of the report results by using the !# condition in Logoff Date field on the report selection pane. This condition can also be used to other characteristics.
Keywords
hashtag; not assigned; User Logon Activity; incorrect data; report; , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To