Business Intelligence errors
Posted: Wed Oct 11, 2023 7:40 am
Don't shoot me if this is the wrong place, your support department said you are handling all BI issues as well now...
using BI i'm running a query selecting from asset service levels as:
select * from simpro_asset_service_levels where asset_id=
This is returning me a Next Service Date of 30 September 2025.
If I look at that asset in simPRO OR via the API I am told its 28th June 2024 (and maintenance planner is relying on this date).
is there a reason that the BI tool doesn't return the data as I expect?
using BI i'm running a query selecting from asset service levels as:
select * from simpro_asset_service_levels where asset_id=
This is returning me a Next Service Date of 30 September 2025.
If I look at that asset in simPRO OR via the API I am told its 28th June 2024 (and maintenance planner is relying on this date).
is there a reason that the BI tool doesn't return the data as I expect?