OBIEE Hint when having aggregation(sum) in the report/dashboard — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Hint when having aggregation(sum) in the report/dashboard

Question
1
Views
0
Comments
3289203
3289203 Rank 3 - Community Apprentice

Hi ,

I have a scenario where iam pulling sum(colum1) and adding an evaluate function in the same analysis for OBIEE dashboard/report.

EVALUATE('/*+LEADING(Table_object_name) parallel(Table_object_name,4) */ %1', 0 )

When this gets converted to SQL  the hint moved to second or lower column and oracle doesnt recognise the hint and is excluding it as some comment in the sql generated.

Ex:  Query under session monitor looks like this

select sum(Table1.col2) as c1,

  /*+LEADING(Table_object_name) parallel(Table_object_name,4) */ Table_object_name.Col1 as c2  from table1;

Is there any way i can force obiee to make this to use col1 as the first value to be placed in the SQL

I tried to force the SQL under advance tab it dint work.