3751241 - User Logon Activity Report Odata Returns Only Last 30 Days Data

User Logon Activity Report Odata returns  last 30 days data only, filters for older date ranges return no results.

SAP Cloud for Customer core applications

1. Go to the Business Analytics work center.
2. Open the Design Reports view and select the User Logon Activity report.
3. Choose Build OData Query.
4. Select required fields and set a Logon date field filter for an older date range (for example, a past month beyond the last 30 days).
5. Run the OData query and observe that only the last 30 days are returned and older dates return no records.

The Logon date variable in the standard User Logon Activity report is configured as a fixed value selection for the last 30 days, and OData respects this initial selection, excluding older dates.

1. Create a copy of the standard User Logon Activity report.
2. In the copy, open the variable settings (step 5) and change the Logon date variable from a fixed/interval setting for the last 30 days to Any selection; remove any fixed last-30-days restriction.
3. Save the copied report.
4. Use Build OData Query on the copied report, select required fields, and define the Logon date filter for the desired historical range.
5. Execute the OData query; historical data beyond the last 30 days should now be returned.

• Note 2857478 - The Report User Logon Details Stores the Logon Data for OData Calls

user logon activity, odata, last 30 days, older data missing, logon date filter, build odata queries, business analytics, report variables, initial selection, any selection, historical data, analytics report, date range filter, c4c reporting, odata query , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem