In Toad for Data Analysts 2.5.1, after generating a heterogeneous query in the Query Builder, and passing it to the pivot table, itshows all data as 0.00, when adding columns fromthe heterogeneous query. The graph is also not populated. A normal query works ok.
In version 2.5, the same heterogeneous query would return data.
Waiting for fix in a future release of Toad for Data Analysts.