I have installed SAP__TE_GEN_IM_EXPENSEENTRY Business Content in SAC and am bringing in data from Concur.
It uses ExpenseEntries query to bring data from Concur. However this pre defined query has NO date filters and our data is over 1M records going back 15 years in Concur. This causes the data load into SAC to fail each time as it is over 800,000 rows.
All the other query filters are extremely specific and do not allow multiple selection (e.g. reportID for one expense report) or extremely broad (hasAttendees) and don't filter down the data sufficiently (or only bring in 10 lines of 1 specific expense report).
Is there a way to :
1. Add a date filter (submitted on, created on, etc) to the predefined ExpenseEntries query? e.g. Last 2 years of expense entries.
2. Alternately, add a multiple selection to an existing filter field (like ExpenseType Code)?
3. Alternately, add a new query to use instead of ExpenseEntries, to bring in Expense Entries with filters? I have looked inside Concur and don't see the original ExpenseEntries report for modification.
As it is, it doesn't seem possible to load data when the source is a large data set in Concur.
Thanks, AB