Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OWB 9i Count Bug

Status
Not open for further replies.
zephan

zephan

Programmer
Jan 14, 2002
217
A2
Hi All,
When I use count function in an aggregator (OWB 9i), the expression type is set by default to the counted item. Ie if I use count(some_date) the type is set to date and grayed (you cannot change it). How could I fix this. Also, I need to be able to count distinct values, I know I can use Dedup operator but to have the clause DISTINCT in the count would be great, any workaround.
Regards,
Zephan
 
Status
Not open for further replies.

Similar threads

dbrs4me
  • Locked
  • Question
Book Search - Oracle OWB and OBIEE
Replies
0
Views
61
dbrs4me
dbrs4me
fharizal
  • Locked
  • Question
OWB: HELP..... 1
Replies
2
Views
64
Nuffsaid
Nuffsaid
naren044
  • Locked
  • Question
What is difference between count(*) and count(1)
Replies
1
Views
45
Hans63
Hans63
brokenbone
  • Locked
  • Question
Error creating repository user in OWB
Replies
1
Views
59
brokenbone
brokenbone
uparna
  • Locked
  • Question
Problem with OWB Mapping - hanging in there !
Replies
4
Views
58
uparna
uparna

Part and Inventory Search

Sponsor

Back
Top