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!

EVALUATE(dense_rank() over (PARTITION BY %1 ORDER BY %2'

198237Mar 12 2009 — edited Mar 12 2009

I'm using this statement in OBIEE (EVALUATE(dense_rank() over (PARTITION BY %1 ORDER BY %2' as integer, "-tabel1"."kolom","tabel2".kolom)).
The %1 parameter comes from another table as the %2 parameter. There is no direct join between these tables. This causes an cartesian product. How can i solve this the easy way. Should I create a view to calculate the top 10 and import this in the ph layer or is there an other way.
We use these top 10 calculations for many things.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2009

Added on Mar 12 2009

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

1 comment

1,216 views