BW Scenario: Cross-Application Time Sheet

This scenario enables you to analyze different Cross Application Time Sheet data from SAP R/3.

InfoCubes

  • Time Sheet (Technical Name: 0CATS_1)
  • Time Sheet Approved (Technical Name: 0CATS_C01)
  • Time Sheet for Approval (Technical Name: 0CATS_C02)

Key Points

  • Actual Times on Internal Orders: This query determines the actual times recorded in the Cross-Application Time Sheet that employees worked on particular internal orders in one quarter.
  • Actual Hours: This query is used to determine the number of hours recorded by an employee or group of employees. Managers can use the query to check their employees' utilization and therefore determine whether they have free capacity. Consultants can use the query to check the number of hours they have available.
  • Actual Times on Network Activities: This query determines the actual times recorded in the Cross-Application Time Sheet that employees worked on particular network activities in one quarter.
  • Tasks: This query displays the sum of working times for any organizational unit. The sum of working times is displayed according to task type and as a total sum for each organizational unit. When you start the query, you can enter an organizational unit as the starting point. The query then not only displays the sum of working times for the specified organizational unit, but also the sum of working times for all subordinate organizational units. However this is dependent on your authorizations. This query can also display employees' organizational reassignment.
 

Scenario Documentation
Scenario Overview
Business Process Procedure


Scenario Installation
Scenario Installation Guide
Building Blocks
I00: Essential Information for SAP Best Practices BI
B84: BW Connectivity
B03: General Settings BW Integration
D19: Cross-Application Time Sheet – Time Sheet Approved
D20: Cross-Application Time Sheet – Time Sheet for Approval