Hi Team,
This highlighted subject report working fine in the old version of 2017.3.5, but now not working in the latest version of 2020.2.5 (we migrated recently) if we copied the same SQL command pasted over here.
Report Name : 90/95/99th Percentile Traffic Rate - Last 7 Days ( working based on SQL query).
Working - 2017.3.5
Not working - 2020.2.5
the same command we are using, but not working.
Issue : Cannot find either column "dbo" or the user-defined function or aggregate "dbo.GetInBpsPercentile", or the name is ambiguous.
Note : In 2020.2.5 customized report available in the format of SWQL, it takes more time and most of the times failed while pulling report.