Oracle Analytics Cloud and Server

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

BI Publisher conditional grouping one group only

Received Response
32
Views
2
Comments

Summary

Break one business unit by department depending on certain account ranges

Content

Pleaee help, I'm a novice BI creator.

I need to split group in report depending on range value. The report already has 5 groups, I need the top level group to split when a certain business unit and department value range of values. The split only will happen with one business unit. 

Report is run from PSoft query based on run control in Peoplesoft.

What's the best way to achieve this?

 

Code Snippet

Range Value:
if (DEPTID >= '6325000' and deptid <= '6328000' then
'Funky'
else
''
Tagged:

Answers

  • Chris E
    Chris E Rank 1 - Community Starter

    Will not allow deletion of post. There have been no replies for solution, so post is useless and taking up space. I'm looking for solutions, not unanswered questions.

  • Ron-92886
    Ron-92886 Rank 3 - Community Apprentice

    Wouldn't a IF statement after the first for-each do the trick?