OBIEE 12c - BI Server generating ROW_NUMBER() in query

Avinash Pentyala

Hi All, I am using sample snowflake schema, while creating report BI generating ROW_NUMBER()  over on each column.

kindly suggest how to avoid/disable this??

sample query

select

T81504."ACC_OPN_DT" as c8,

T81504."PROD_ID" as c9,     

   T81504."CUST_ID" as c10,   

ROW_NUMBER() OVER (PARTITION BY T81495."SEGMENT_OWNER", case  when T81504."PROD_ID" in ('0040004', '0040017', '0040029', '0040036', '0040058', '0040059', '0040067', '0040068') then T81504."CUST_ID" end    ORDER BY T81495."SEGMENT_OWNER" DESC, case  when T81504."PROD_ID" in ('0040004', '0040017', '0040029', '0040036', '0040058', '0040059', '0040067', '0040068') then T81504."CUST_ID" end  DESC) as c11,

  case  when T81504."PROD_ID" in ('0040004', '0040017', '0040029', '0040036', '0040058', '0040059', '0040067', '0040068') then T81504."CUST_ID" end  as c12,     

    ROW_NUMBER() OVER (PARTITION BY T81495."SEGMENT_OWNER", case  when T81504."PROD_ID" in ('0040010', '0040048', '0040055', '0040056', '0040057') then T81504."CUST_ID" end  ORDER BY T81495."SEGMENT_OWNER" DESC, case  when T81504."PROD_ID" in ('0040010', '0040048', '0040055', '0040056', '0040057') then T81504."CUST_ID" end  DESC) as c13,

    case  when T81504."PROD_ID" in ('0040010', '0040048', '0040055', '0040056', '0040057') then T81504."CUST_ID" end  as c14, 

      ROW_NUMBER() OVER (PARTITION BY T81495."SEGMENT_OWNER", case  when T81504."PROD_ID" = '0040001' then T81504."CUST_ID" end  ORDER BY T81495."SEGMENT_OWNER" DESC, case  when T81504."PROD_ID" = '0040001' then T81504."CUST_ID" end  DESC) as c15,  

case  when T81504."PROD_ID" = '0040001' then T81504."CUST_ID" end  as c16     

                        from   

        (     "T_MARKET_CUSTOMER" T81472 /* Dim_Customers */ inner join "MKTG_SEGMENT" T81495 /* Dim_Customer Segments */ 

On T81472."CUST_ID" = T81495."SEGMENT_PRTY_ID") left outer join                                        "MKTG_AGMT" T81504 /* Fact_Agmt */

On T81472."CUST_ID" = T81504."CUST_ID"         

              ) D1

[Deleted User]

"

Please read point number 10 attentively: "Format code you provide. This make code readable, regardless if it’s Java, PL/SQL or the source of a .jsff page."

Avinash Pentyala

Thanks,Formatted

Avinash Pentyala

Using TeraData as data source

Avinash Pentyala

Hi,

Issue with case statement at logical column level, when I write the case statement in analytics side working fine.

reference: OBIEE 11g - Result Set Not Correct Due To Case Statement Applied Within Presentation Services ( Doc ID 1948277.1 )