Create an OTBI Analysis to Fetch TOPN/BOTTOMN Records
Here's how you can create an OTBI Analysis to fetch TOPN/BOTTOMN records.
Create an OTBI Analysis to Fetch TOPN/BOTTOMN Records
-
Start in Oracle Transactional Business Intelligence
-
Click Create and choose Analysis to create a new analysis.
-
In Select Subject Area, choose Workforce Management - Worker Assignment Real Time.
-
Expand the subject area and select the columns:
-
Expand Business Unit.
-
Choose Business Unit Name.
-
Expand Worker Assignment.
-
Choose Head Count. Add columns to the report.
-
-
In the Head Count column, click the Setup icon.
-
Click Filter. In the New Filter dialog:
-
For the Operator, choose is in top..
-
For the Value, choose 5.
-
Click OK. Add a filter to the Head Count column.
-
-
Click the Results tab. This shows the top 5 business units and their respective headcounts.
-
Click the Criteria Tab. Similarly, you could also find the ones that are in the bottom 5.
-
Click the Edit Filter icon.
-
Change is in the top to is in the bottom.
-
Click OK. Return to Results tab.
-
Click Table Properties. In this case, there are more than 5 results because multiple business units have the same head count.
-
Click Content Paging.