Work Instruction
Functional Area: Business Warehouse / Using Conditions in BW 7.0
PurposeBusiness Warehouse
Use this procedure to filter the data in a Business Warehouse report based on a value or range of values of a key figure.
Prerequisites
Access to UC Flex Business Warehouse
Menu Path
SAP Easy Access Menu - Reports in various folder by report type.
Browser Bookmarked Reports
Helpful Hints
  • Most of the same options are available whether the user right clicks on column titles, data in the column, or values in the navigation block.This includes the option tocreate or activate a condition.
  • Extreme caution shoud be used whenactivating conditionswithin the BW report. Incorrect choices of values will produce faulty reports.
  • All functions work the same in all Business Warehouse reports, regardless if the report is HRor Financial.
  • Business Warehouse is separate from the UC Flex HR and Financial system.
  • The Business Warehouse receives data nightly from the UC Flex HR and Financial system.
  • Data is retrieved for the reports and cannot be changed by the user.
Terminology
Characteristics –A business object, such as an Asset, a Vendor, a Fund or a Fiscal Year. It is a broad representation of the business object.
Characteristic Values– A characteristic’s identifier. Examples of values for the Fund characteristic might be “Faculty Club,” “PPR-Dermatology,” and “Army ROTC.”
Attributes –Provide additional information about a characteristic such as the valid-to and valid-from dates for a Grant or the address of a Vendor.
Key Figures– Values or quantities, such as amount, fixed costs, or number of employees. In simple terms, you can do math on it.
Variable– Selection criteria used to limit the results of a report.
Variables Entered– An area of the report that shows the variables that were entered by the user.
Navigation Block– An area of the report that shows some of the columns that can be added to or deleted from the report.
Drilldown– The Variables and Key Figures available in a BW report represent the report’s columns and rows. Drilldown is used to change the layout of a report by adding, deleting or changing the order of the columns and/or rows.
Conditions– Element of a report which enables the user to filter using a multiple variable approach with one characteristic and one key figure. For example, creating a report version which has displays only those positions that earn greater than $20,000 per year.
11/4/2017
Ver: Rev 2013-1 / BW 7.0 Using Condtions.udc
© University of Cincinnati / 1/1
Work Instruction
Functional Area: Business Warehouse / Using Conditions in BW 7.0
Procedure
1. / Runa Business Warehouse report.
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

2. / Right-click in the column data Mail Svc Worker-U .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

3. / Click Conditions Create New Condition .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

4. / Click the Threshold value condition radio button .
Normally users at UC only build Conditions based on Threshold Values. Ranked List and Mixed Conditions are also available as options.
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

5. / Click the Next button .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

6. / Click the Key Figures drop down .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

7. / Click the FTE% option .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

8. / Click the Operator drop down .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

9. / Click the less than < option .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

10. / As required, complete/review the following fields:
Field / R/O/C / Description
Value / Required / The data the Operator will use when applying the chosen action
Example:
100
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

11. / Click the Next button .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

12. / Click the Next button .
Most users at UC who create and utilize Conditions select Detailed characteristic along the Rows for their simple Threshold Value Condition settings. More complex Conditions can be built by selecting other options from the Define Condition menu.
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

13. / As required, complete/review the following fields:
Field / R/O/C / Description
Description: / Required / Text to define an object
Example:
FTE < 100%
/ The description input here will be the Name of the Condition.
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

14. / Click the Finish button .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

15. / Right-click in the column data Joseph Fayez label .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

16. / Click Filter Conditions FTE < 100%Change Condition menu item .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

17. / As required, complete/review the following fields:
Field / R/O/C / Description
Value / Required / The data the Operator will use when applying the chosen action
Example:
50
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

18. / Click the Next button .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

19. / Click the Next button .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

20. / As required, complete/review the following fields:
Field / R/O/C / Description
Description: / Required / Text to define an object
Example:
FTE < 50%
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

21. / Click the Finish button .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

22. / Right-click the column title Position label .
/ The changed condition is applied to the column.
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

23. / Click Filter Conditions Create New Condition .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

24. / Click the Threshold value condition radio button .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

25. / Click the Next button .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

26. / As required, complete/review the following fields:
Field / R/O/C / Description
Value / Required / The data the Operator will use when applying the chosen action
Example:
100
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

27. / Click the Next button .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

28. / Click the Next button .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

29. / As required, complete/review the following fields:
Field / R/O/C / Description
Description: / Required / Text to define an object
Example:
FTE = 100%
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

30. / Click the Finish button .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

31. / Click the Expand tray button .
/ Two Conditions are active that eliminate all of the data on the report. (FTE = 100 and FTE < 50) Since there is no report, no action can be accessed with a right click on any column title or data value. Actions will need to be performed from the Navigation Block.
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

32. / Right-click Org Unit .
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

33. / To deactivate a condition, click Filter Conditions FTE = 100% Condition Active menu item .
/ Clicking on Condition Active will toggle the condition on and off. If a checkmark is present the condition is on.
BEx Web - HR101: Historical Employee Basic Data on a Selected Date - Windows Internet Explorer

34. / Click the Close Tab button to exit the report. If now using windows tabs click the close window button to exit the report.
/ If the report hasn't been bookmarked in the browser the Condition(s) will be lost.
11/4/2017
Ver: Rev 2013-1 / BW 7.0 Using Condtions.udc
© University of Cincinnati / 1/28
Work Instruction
Functional Area: Business Warehouse / Using Conditions in BW 7.0
Result
You have created and used conditions.
11/4/2017
Ver: Rev 2013-1 / BW 7.0 Using Condtions.udc
© University of Cincinnati / 1/28