You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

trying to group by a column in OTBI

Question
21
Views
0
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics

Summary

Trying to emulate the SQL Group by below in OTBI

Content

Select        pt.task_number,
       sum(peia.projfunc_raw_cost )                         
FROM    pjc_exp_items_all peia,
       pjf_projects_all_b ppb,
        pjf_tasks_v pt
Where
ppb.project_id=pt.project_id
and
pt.task_id= peia.task_id
and task_number='001'
group by task_number
      

Code Snippet

Select        pt.task_number,
       sum(peia.projfunc_raw_cost )                          
FROM    pjc_exp_items_all peia,
       pjf_projects_all_b ppb,
        pjf_tasks_v pt
Where
ppb.project_id=pt.project_id
and
pt.task_id= peia.task_id
and task_number='001'
group by task_number
       

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!