Home » Fusion Middleware & Colab Suite » Business Intelligence » Distinct Count in BI Publisher
Distinct Count in BI Publisher [message #452045] Mon, 19 April 2010 13:01 Go to next message
aaashwini@gmail.com
Messages: 24
Registered: May 2009
Junior Member
Hi,

I need to use the feature distinct count in BI Publisher. So, if the distinct count is 1 then do display certain information else display some other information.

I'm using this particular syntax: <?count(distinct-values(ProjectNumber))?>

Please let me know if there is some JAR file is missing or is there some other method to achieve distinct count.

Many Thanks in advance

But it thorws out a Java Exception:
************************************
at java.lang.reflect.Method.invoke(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeNewXSLStylesheet(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
at RTF2PDF.runRTFto(RTF2PDF.java:629)
at RTF2PDF.runXDO(RTF2PDF.java:439)
at RTF2PDF.main(RTF2PDF.java:289)
Caused by: oracle.xdo.parser.v2.XPathException: Function 'distinct-values' not found.
at oracle.xdo.parser.v2.XSLProcessor.reportException(XSLProcessor.java:806)
at oracle.xdo.parser.v2.XSLProcessor.newXSLStylesheet(XSLProcessor.java:571)
... 14 more

********************************************************

Re: Distinct Count in BI Publisher [message #452208 is a reply to message #452045] Tue, 20 April 2010 11:29 Go to previous messageGo to next message
vamsi kasina
Messages: 2095
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
As I've mentioned in the Forum Guide,Quote:
1. Have you searched in the BI Blog?


Check this.

By
Vamsi
Re: Distinct Count in BI Publisher [message #452209 is a reply to message #452208] Tue, 20 April 2010 11:34 Go to previous messageGo to next message
aaashwini@gmail.com
Messages: 24
Registered: May 2009
Junior Member
Yes I did search and got the result as to use the following to get distinct count: <?count(distinct-values('DEPT')?>

But apparently this doesn't work and throws the above error pasted in my previous reply.

Re: Distinct Count in BI Publisher [message #452210 is a reply to message #452209] Tue, 20 April 2010 11:39 Go to previous messageGo to next message
vamsi kasina
Messages: 2095
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Quote:
Yes I did search and got the result as to use the following to get distinct count: <?count(distinct-values('DEPT')?>
Can you read the blog link once again, especially the second last line?

By
Vamsi

[Updated on: Tue, 20 April 2010 11:48]

Report message to a moderator

Re: Distinct Count in BI Publisher [message #452215 is a reply to message #452210] Tue, 20 April 2010 12:11 Go to previous messageGo to next message
aaashwini@gmail.com
Messages: 24
Registered: May 2009
Junior Member
Does this mean that Oracle X-Path does not support this distinct-values keyword ?
The XPAth library used in Apps is different from the generic X-Path.

Please let me know if there is any other way to achieve this.

Re: Distinct Count in BI Publisher [message #452219 is a reply to message #452215] Tue, 20 April 2010 13:00 Go to previous messageGo to next message
vamsi kasina
Messages: 2095
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I think you missed "xdoxslt:distinct_values". Please crosscheck.

By
Vamsi
Re: Distinct Count in BI Publisher [message #452348 is a reply to message #452219] Wed, 21 April 2010 08:57 Go to previous message
aaashwini@gmail.com
Messages: 24
Registered: May 2009
Junior Member
Thanks Vamsi...Distinct-values is working after adding the prefix xdoxslt....

Vamsi-
I have one more question.Can you please let me know if there is a format to enable red color for negative numbers alone and positive numbers will be shown as it is.

I'm currently using the format: $#,##0.00;($#,##0.00)
But the problem with this format is it appends $ sign before the numbers. This is not acceptable by the client. If I remove the $ sign from the format and re-execute then the format does not work in Excel output alone and works in HTML and PDF output formats. But the client wants the output in Excel only. Please let me know if there is any trick to achieve the functionality.

Many Thanks
Ashwini
Previous Topic: Writeback Option in OBIEE
Next Topic: Confused on BI Publisher and BI Presentation Services
Goto Forum:
  


Current Time: Mon Jul 28 19:13:30 CDT 2014

Total time taken to generate the page: 0.09542 seconds