Tuesday, January 27, 2009

OBIEE Creating a Yamazumi Graph

A Yamazumi chart is a stacked bar chart that shows the balance of cycle time workloads between a number of operators typically in an assembly line or work cell. The Yamazumi chart can be either for a single product or multi product assembly line.
Yamazumi is a Japanese word that literally means to stack up.
Toyota uses Yamazumi work balance charts to visually present the work content of a series of tasks and facilitate work balancing and the isolation and elimination of non value added work content.

clip_image002

1 Instructions

1.1 Minimum data

clip_image002[4]

The minimum available data columns are:

  • EMP_NO: identifies the employee
  • TASK_START_TIME: Task Start Time
  • TASK_ORDER: RCOUNT for the tasks of the employee during the period, based on the TASK_START_TIME { RCOUNT(YamazumiTable.TASK_START_TIME by YamazumiTable.EMP_NO) }
  • TASK: Identifies the task
  • DURATION: TASK duration in minutes

clip_image004

1.2 Pivot Table

The base data has to be transformed into a pivot table:

clip_image006

Set the aggregation rule for duration to first:

clip_image008

1.3 Adding a graph

Select

clip_image010

Chart only, Horizontal Bar, 2D Stacked, Rectangle

Set legend to None

clip_image012

1.4 Colouring the Task:

Go to Format Chart Data > Conditional

clip_image014

Select add condition for TASK

clip_image016

Set the colour for each TASK

clip_image018

1.5 Creating a legend

clip_image020

Set the background colour for each task:

clip_image022

1.6 Organize the compound view:

clip_image024

Till Next Time

2 comments:

Stijn said...

Hmm.. where have I seen this before.. ;)

Anonymous said...
This comment has been removed by a blog administrator.