Daily Archives: February 1, 2010

New and Upcoming Events from the #1 Supply Chain Resource Site

The Sourcing Innovation Resource Site, always immediately accessible from the link under the “Free Resources” section of the sidebar, continues to add new content on a weekly, and often daily, basis — and it will continue to do so.

The following is a short selection of upcoming webinars and events that you might want to check out in the coming weeks:

Date & Time Webcast

11:00 GMT-08:00/AKDT/PST

Governing Your Outsourcing Portfolio: Are You Achieving Maximum Value? Presented by EquaTerra

Sponsor: Sourcing Interests Group


11:30 GMT-05:00/CDT/EST

People – The Next Competitive Advantage in Your Supply Chain

Sponsor: Eagles Flight


10:00 GMT-07:00/MST/PDT

Tips For Selecting the Right ERP Software For Your Organization

Sponsor: Panorama Consulting Group


14:00 GMT-05:00/CDT/EST

Integrating AP Best Practices with Technology

Sponsor: The Accounts Payable Channel

Dates Conference Sponsor
2010-Mar-1 to


Gartner Business Process Management Summit

London, England, UK (Europe)

2010-Mar-1 to


ProcureCon Indirect 2010

Charlotte, North Carolina, USA (North-America)

2010-Mar-2 to


International Materials Handling Exhibition

Birmingham, England, UK (Europe)

2010-Mar-2 to


The Strategic Supply Chain Management Forum

Toronto, Ontario, USA (North-America)

The Conference Board of Canada
2010-Mar-2 to


Gartner Business Intelligence & Information Management Summit

Sydney, Australia (Australasia)

2010-Mar-2 to


Process Management Academy Europe 2010

Dusseldorf, Germany (Europe)

ARC Advisory Group
2010-Mar-3 to


6th Annual India Trade & Export Finance Conference

Mumbai, India (Asia)


They are all readily searchable from the comprehensive Site-Search page. So don’t forget to review the resource site on a weekly basis. You just might find what you didn’t even know you were looking for!

And continue to keep a sharp eye out for new additions!

Spend Analysis V: User-Defined Measures, Part 2

Today’s post is from Eric Strovink of BIQ.

Sometimes you want and need control over how (and when) measures are calculated. Such measures are termed “user-defined” measures.

As we saw previously, there are two kinds of user-defined measures:
(1) post-facto computations that are performed after transactional roll-up (the usual definition), which we’ll consider here, and
(2) those that are performed during transactional roll-up, which were covered in Part 1.

In the above example the gray “Ref” columns are filtered on commodity count/spend in Q1 2003, and the normal column is filtered on commodity count/spend in Q1 2004. If we then additionally filter on four business units:

we can now see the quarter-on-quarter comparison for just those business units:

You can see that two filter operations are occuring every time the dataset is filtered; one for the regular filter above, and one for the reference filter, modified by non-conflicting filter operations. This “dynamic” reference filtering can be quite powerful, since the relationship between the two periods is now available at any filter position in the dataset.

Now, let’s add a post-rollup (“nodal”) computed measure that calculates the %difference between these columns. The code reads like this:

$%Diff$ = ($Amount$-$RefFilter4.Amount$)/$RefFilter4.Amount$ * 100;

Now, if we sort top down by %difference, we can see quite clearly the quarter-on-quarter difference sorted by worst to best, considering just the four cost centers above:

This percentage difference is available to all analysis modules, because it is calculated at every node, not just at the nodes that are currently being displayed.

Next installment: Meta Dimensions; but I’ll take a few weeks off before diving back in!

Previous Installment: User-Defined Measures, Part I

Share This on Linked In