Skip to Content

Access historical data in C4C Reports

Hi Experts,

Can I have an access to historical data in C4C reports?

I mean can I check what was the status of an activity on a particular date in past?

I need to design a report where I can see which all activities were open on a particular date in past.

At present, datasources in the system provides current data.

So how can I achieve it?

Waiting for your valuable responses.

Thanks in Advance,

Gayatri

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 19, 2015 at 11:31 AM

    Hi Gayatri,

    as of today, you can not access historic data other than using the changes tab on the business object. It is not exposed as data source or service right now.

    With the feature set as of today a report like this can not be designed.

    Alternatively, you could do some custom development which runs a job (MDRO) every day and creating and storing a list with open activities. This list could be made available via report.

    Best Regards,
    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2015 at 04:04 PM

    The Ticket is the only object that has historical/point in time reporting available. If you want this type of reporting (this is a typical data warehouse/analytics usecase) you will need to periodically export the C4C data into a data warehouse solution such as BW or capture snapshots/copies of the object and store these snapshots/copies in a custom object via SDK and then create reports on top of the custom object.

    Add comment
    10|10000 characters needed characters exceeded