How to control row-number () function in OBIEE 12c

Ramamohan Reddy

I created a OBIEE report using Answers. When I ran the report getting empty data.
When i checked the log file, I found that the Physical SQL in test has
ROW_NUMBER ()
OVER
(
PARTITION BY c1, c4, c5 order by c1,c4,c5) whereas the physical SQL.

Query example:
select d1.c1 as c1,d1.c2 as c2,d1.c3 as c3,d1.c4 as c4 from
( select 0 as c1,d1.c2 as c2,d1.c3 as c3,d1.c4 as c4,
ROW_NUMBER() over (partition by d1.c3 order b d1.c3 asc) as c5
from ( select sum(T2225.sales) as c1,
T2224.prod_name as c2,
T2224.prod_item as c3
where (T2225.prod_id=T2224.prod_id)
D1 ) D1 where (D1.c5=1)
order by c3) where (D1.c5=1)
order by c3) D1 where rownum<4000001


How this Partiton is done in OBIEE. 
Whether there are any settings to control it? How OBIEE does this Row Number() Partiton ?

Please help!

Gianni Ceresa

Double posting is against the rules of the forum.

What is the difference between this and https://community.oracle.com/tech/apps-infra/discussion/4478943/how-to-control-rownumber-function-in-obiee-12c#latest ?

Your thread is far from being explicit in what you look for.

OBIEE generates queries based on models and formulas used. You don't have to ask yourself how to change the physical query but you need to make sure you modeled things correctly. If your model is right, your query will be right (and it doesn't matter how it does look like, it will do the job you need).