Richard Spencer
posted this on November 10, 2011 17:16
We own multiple companies or Divisions and each company has some common metrics (like financial statement stuff) as well as some unique metrics. For the common metrics I would like to be able to set up a group of common metrics for a specific company but distinguish them from the same metrics for another company. If I import say the P&L pack metrics from the store it looks like I have to then edit every metric to add something in the description that distinguishes that metric as belonging to "Company X" and this takes a long time for a large group of metrics. If I dont do this then it is hard to know what metrics (and data) apply to what company as the system ends up with lots and lots of "duplicate" KPIs in it (e.g. Total Sales appears 5 times if I have 5 companies). Is there a smarter/quicker way to deal with this issue? I thought about using breakdowns under each metric for each company but this gets very confusing as the parent metric (say Total Sales) is really a meaningless one to almost all users, especially when we do not add up or consolidate all companies anyway as each operates at an autonomous entity.
You should consider adding a "Division" dimension to the data that would allow the same metric definition to be used for each division but would automaticallly create distinguishable Division-specific metrics in the system to choose from when creating dashboards and when entering scores. Alternatively (but less elegant), would it be possible to take a set of common metrics and duplicate them while appending a unique Division identifer to the description?