OraFAQ Forum: Business Intelligence » Distinct Count in BI Publisher

Home » Fusion Middleware & Colab Suite » Business Intelligence » Distinct Count in BI Publisher

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Distinct Count in BI Publisher [message #452045]

Mon, 19 April 2010 13:01

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

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

Report message to a moderator

Re: Distinct Count in BI Publisher [message #452208 is a reply to message #452045]

Tue, 20 April 2010 11:29

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

As I've mentioned in the Forum Guide,Quote:

1. Have you searched in the BI Blog?

Check this.

By
Vamsi

Report message to a moderator

Re: Distinct Count in BI Publisher [message #452209 is a reply to message #452208]

Tue, 20 April 2010 11:34

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.

Report message to a moderator

Re: Distinct Count in BI Publisher [message #452210 is a reply to message #452209]

Tue, 20 April 2010 11:39

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

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.

Report message to a moderator

Re: Distinct Count in BI Publisher [message #452219 is a reply to message #452215]

Tue, 20 April 2010 13:00

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

I think you missed "xdoxslt:distinct_values". Please crosscheck.

By
Vamsi

Report message to a moderator

Re: Distinct Count in BI Publisher [message #452348 is a reply to message #452219]

Wed, 21 April 2010 08:57

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

Report message to a moderator

Previous Topic:	Writeback Option in OBIEE
Next Topic:	Confused on BI Publisher and BI Presentation Services

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 18:11:06 CST 2025