Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using filter with count distinct

784355Aug 23 2011 — edited Mar 2 2012

Hello,

Using obiee 11g
I am having a problem,when using like
filter(count(distinct(table1.col)) using (table2.col1=table3.col2))

When i am using like this in my analysis, its calculating like only count of count and leaving the filter.
My problem is i cannot have a measure defined in RPD i need to have in report itself.
Any solution for this?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2012

Added on Aug 23 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

2 comments

578 views