simPRO API Forum

Hi,

I found that the schedule breakdown report may not be displaying all rows when I download the report. As a workaround solution, we are downloading smaller chunks of the data and combine them by myself.

Therefore, I am looking for other ways to have the same report in SimPRO BI reporting. Is it possible for me to have the exact same SQL queries to be used in "BI Reporting" to generate the same report in live system?

Thanks,

You don't want to look at Live (now) data?

BI Reporting is based of a replicated database so you won't see today data.
My BI Reporting data is generally >24hrs old, I'm guessing this will depend on location

Thanks for your reply.
It's okay if the data is not up to today. I only need it to be up to end of month.
The issue of using Live data report is that - I found Live data is not displaying all the data I need, even after I press "All" button. I think it is due to the large volume of data in the report. Therefore, I am looking for a solution to obtain the complete data set.
Do you know if there is any method I can obtain the same data from BI reporting please?

So I tried this in BI Reporting and can replicate the Schedule Breakdown report but not how I thought I would.
We use multi company and in SimPRO can do each Company separately. I cannot do them separately in BI Reporting.

For BI Reporting I used SimPRO Schedule table and filtered Date on last month.
But to get a matching count I needed to select all 4 of our companies as well as 'All Companies'

Doing this any other way in BI reporting is missed the Activities

I can therefore only match it to SimPRO if in SimPRO I select all four companies.
So I feel the BI report is flawed.

It does work correctly when using the API