VERIFIED SOLUTION i
X

Values not displayed in bar graph or pie chart reports in Sagent

Issue

In Analysis sink "bar graph" and "pai chart" reports does not display data in Design studio. Values are only visible when set from the wizard within Weblink client.

Cause

The query created at runtime by Design Studio contains pipe characters (||).  These characters make it an invalid Oracle query and as a result no records are returned and displayed in the chart.

Resolution

UPDATED: March 22, 2017


Remove pipe characters (||) and refine the query in SQL Query Transform as per the underlying database in use.
 

Environment Details

Product Feature: Reports
Operating System: Windows XP, Windows Server 2008 R2
Database: Oracle
Product version: 6.7

Downloads

  • No Downloads