Saturday, October 26, 2013

How to unleash the power of dynamic subsets to speed up budgeting process

To identify data problem in budgeting process, we can generate summary report to help. However, this approach has two issues:

Development team needs to build report via report studio with cube based framework manager

User need to look at report, then go to contributor to edit data, it is very cumbersome process

Dynamic subsets are here to rescue, which will overcome two mentioned issues above:

We can simple leverage current existing cube, the only thing we need to do is to create a new view for business to use.

From business user point of view, they don’t need to go back and forth to identify locations with problems; instead, they can directly input data within view. In addition, data set with exception will be reduced during process.

To demonstrate this idea, a simple cube has been built as below

The highlighted cells have problem, because there are sales, but no cast is associated. Practically, this is a very big data set.

To allow business users to identify this problem, we can build two dynamic sets for this issue.

Customers that has sales but no cast at Year level

Build a subset to show only customers that has sales but no cast at Year level