Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE Hint when having aggregation(sum) in the report/dashboard

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.