Assigning a Drill-down View

To specify a drill-down view for a granularity, follow the instructions "How to Add Granularities to a Metric Definition" for editing the granularities for a metric definition. Add the view file (.axvw) name of the view to load in the Edit Granularities form.

The program keeps Drill-down views in the Metric Granularity Assignments (afm_metric_grans) table. As such, each granularity for each metric definition can have its own drill-down view.

Typically you would design the drill-down view for the particular metric. For instance, if your metric was Open Move Requests orders, you would drill-down to a view that listed Move Requests and with a restriction to those that were open.

Passing Parameters to Drill-down Views

You can pass parameters to drill-down views in order to restrict the same view by different criteria based on which particular granularity and bar value the user clicked on.

Metric Name	Collect Group By	Drill-down View
fin_RealEstateOpEx_monthly	all	ab-rplm-cost-mgmt-costs-summary.axvw
fin_RealEstateOpEx_monthly	bu_id (By Business Unit)	ab-rplm-cost-mgmt-costs- by-bu-details.axvw?bu_id={0}
fin_RealEstateOpEx_monthly	bl_id (By Building)	ab-rplm-cost-mgmt-costs-wiz-ls-bl-pr.axvw?bl_id={0}
fin_RealEstateOpEx_monthly	bu_id;bl_id (by Business Unit and Building)	ab-rplm-cost-mgmt-costs-wiz-ls-bu-bl-details.axvw?bu_id={0}&bl_id={1}

The URL value can specify replaceable parameters ({0}) for receiving the afm_metric_trend_values.collect_group_by values, which are semi-colon delimited.

For instance if the URL for the granularity assignment is:

ab-rplm-cost-mgmt-costs-wiz-ls-bu-bl-details.axvw?bu_id={0}&bl_id={1}

and the afm_metric_trend_values.collect_group_by value for the metric value is "Compliance;HQ" (that is "bu_id;bl_id"); then the control would fill the URL parameters in as:

ab-rplm-cost-mgmt-costs-wiz-ls-bu-bl-details.axvw?bu_id="Compliance"&bl_id="HQ"

In this way, the drill-down view can retrieve the parameters from the URL and filter on them, if needed.

For an example of how to define a view that can pull parameters from the URL, please see:

\schema\ab-products\solutions\programming\view\ab-ex-prg-url-parameters.axvw