In analytics, release 1811 brought several innovations, that I will use to demonstrate how a cost center manager gets all necessary information to keep control of his budget on one single page.

To read more about new KPIs we have just delivered, please read on here.

How to create a cost center manager dashboard?

Business requirement

Let’s assume a cost center manager of the financial department. Most important aspects on budget is about travel and externals like auditors or temporary staff. It receives depreciation for the office building and is distributing this and its services to others.

Let’s assume one screen, a dashboard, where he or she can get an immediate overview on events at his cost center or if everything is on track. I’d like to draft how this can be achieved, covering these aspects:

• Actuals for budget consumption.
• Focus on budget consumption for specific cost types: travel cost and external cost.
• Upcoming cost not yet shown at the cost center, such as purchase orders.

To achieve this, I will also use some new features that have been delivered with the last release. My colleague Stefan explains the 1811 additions to Analytics here.

• A dashboard. This is the pane holding the analytical assets.
• Key Performance Indicators (KPI) and KPI Variants. The latter ones are a perfect fit of what we want to achieve. At first, I’ll define a KPI “budget consumption”, which holds the key figure “Actual + Forecast” from a standard report. But I won’t add this to the dashboard, it’s rather a kind of template which allows me to create more specific insights, called KPI variants. Such is a KPI with an additional filter, e.g. my KPI “budget consumption”, but only applied to G/L Account (Origin) “Travel Expense”, “Audit Cost”, or others. The available filters are defined at the level of the KPI, which changes the type to “KPI (filterable)” and allows to create a KPI of type “KPI variant” on top of it, which is nothing else than an application of the filter with specific values. You’ll see this below.
• I will also add an embedded report.

For those who have a reference system available, I’ve created the dashboard using two user roles:

• ADMINISTRATION01, administrator and key user analytics
• FINANCIAL01, manager accounting and HR department.

Assumptions

The example will use a cost center report with forecast. The forecast is today using encumbrance calculation. This needs to be scoped and set-up to get purchase orders in process as a forecast.

Additionally, it is assumed that the CC manager has access to Work Center Insights, work center view Manage Dashboards. If not already done, an administrator needs to adjust his/her user in work center Application and User Management, work center view Business Users.

Step-by-Step guide

Step 1: Adapt the base report

All these steps are to be executed as Key User Analytics.

Step 2: Create a KPI to be used with variants

At first, we will create a KPI measuring the consumption of the budget, taking into consideration forecasted amounts (if encumbrance is scoped). In a second step, we will apply the KPI to two focus area, external expense and travel budget, by creating KPI Variants.

As a key user analytics, perform the following steps.

Step 3: Create KPI variant “travel budget”

Step 4: Create KPI variant “external expense”

Repeat the actions of step 4 or copy the KPI variant, but use these data:

• Name: External Expense Budget
• G/L Accounts on which external expense (purchases, auditing) is being posted to. In my example, it’s 450230 and 511400, but this will be a longer list in a real-life situation.

You will now have 3 KPIs:

Step 5: Create a dashboard “my cost centers”

From now, we will work as the business user, which is the CC manager (FINANCIAL01 in a ByD Reference System).

As the cost center manager, add an empty dashboard. How to do it has been explained in a video. Don’t add a report to the dashboard at first, just create it and pin it.

You will end up with an empty dashboard:

Step 6: Adjust the dashboard

Further possibilities to extend

You can even extend the dashboards with additional KPIs and reports. I’ve used report Expense Reports by Cost Object. To do so, restrict it to the “My Area” cost centers and to expense reports not send, in approval or audit (i.e. that are still in process, status 1 to 3). Delete the date selection. Create a KPI on top of it, based on key figure Cost Center Postings. Now, the dashboard contains an information on upcoming travel cost as well.

Feedback

I hope this blog post helps you to leverage the full potential of SAP Business ByDesign. In case you are adopting this, please let me know by leaving a comment below this post. Or share your ideas, discuss, what’s missing.