Why are we not able to access reports in real time?

[DavidN]

Why are we not able to get reports updated in real time?

[KevinD]

David,

I'm guessing you are referring to Cognos Reporting. The job that updates the data warehouse only runs once a day.  Also, it does take a while for this job to run, so that's why it cannot be real time. 

[michelebard]

Hi there,

It is because all newly added data and or changes made to the system will only be available via Cognos reporting after the overnight processing has taken place or after 24 hours, so, running the report until then should work.

*** If after 24 hours the expected data still do not reflect on the Cognos results, please open a case with Concur Support (Reporting/Analytics).

Thanks

[childerj]

New Concur user here and I am frankly shocked this is the case. With today's technology it should be a no brainer to provide real-time updates for reporting. Very dissapointing.

[cjmarimo]

I suppose Concur and Cognos connect to different databases. This is normally when you have one is a transactional database like Concur, where data update operations are performed. And the other data query like Cognos because queries reduce the performance of a database. For this reason, you have two data base independents.

childerj, you are right. Nowadays, SAP Concur should implement the real-time tecnology for Cognos-Concur.

[childerj]

We have the same issue with our production/reporting DB. We run all our reporting off of a mirrored DB which doesn't impact production and provides data in real time. Very easy to setup.

[dehincome]

Hi, Can you please guide me through the setup?

[samasuraj]

Hi @DavidN 

Topic: Why are we not able to access reports in real time?

Please check the below. Hope this helps.

-----

SAP Concur Analysis/Intelligence uses a separate reporting data warehouse that is refreshed through scheduled processing, rather than continuous live transactional data replication.

The reporting data is refreshed through scheduled background processing, which means newly submitted, approved, or updated expenses may not immediately appear in Cognos reports.

SAP Concur has confirmed that its reporting data warehouse uses a daily refresh process, so these reports are not real-time.

Using a mirrored database for near-real-time reporting is a valid approach when an organization controls its production database and replication architecture.

However, SAP Concur is a cloud-hosted SaaS solution and customers do not have direct access to replicate its underlying transactional database.

Recommendation: If near-real-time reporting is required, discuss supported SAP Concur APIs or integration options with SAP Concur Support. Data could potentially be extracted into an external reporting database, subject to API availability, permissions, and synchronization frequency.

A mirrored database is therefore not a direct, customer-configurable solution for SAP Concur Cognos reporting.

Thanks & Regards

--

Samantha Prathikantam

SF_EC & ECP / SAP Concur Consultant