Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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

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.
0