Jack

NSQL SHOWING INCORRECT RESULTS

Discussion created by Jack on Oct 27, 2010
Latest reply on Nov 1, 2010 by Chris_Hackett
We are using Clarity 12 SP6 along with generic hotfix 009

We have created three dimensional portlet using custom NSQL query. Here
Y-axis will display timeperiod and three metrics columns. X-axis showing 2
columns. Further, we added two more columns in Y-axis which will display row totals.
Among the two row totals, only one column showing correct data, the other row
total column showing value as zero.

Please look at my screenshots for the row-wise totals.

FYI. When I execute the same query in TOAD, i'm able to see the results.

Herewith I have enclosed the NSQL, Oracle functions, screenshots for your
reference.

Attachments

Outcomes