Add a drilldown block to my dashboard

 

You can add a drilldown block that allows you to access greater levels of data detail.

For example, if a dashboard block shows a pie chart with data for two projects, called Parking Extension and Terminal Expansion, and you double-click on Terminal Expansion to expose the vendors on that project:

 

 

To continue the example, when you double-click on Terminal Expansion the to access the vendor information, and the amount associated with the vendors Acme Equipment, Pacific Building Interiors, and L. Loring & Company:

 

 

Note: If you want to use filters on your dashboard blocks, you must first define a drilldown block.

To add a drilldown block to your shell dashboard

1 On the Edit Dashboard window, click Add > Drilldown. The Edit Drilldown Block window opens. Drilldown functionality is supported for charts only, and is not available for grids or tables. Drilldown will stop when a grid or table is encountered.

 

   

This item

Does this

Data Cube

Select the data cube definition to use. Data cubes are queries that can be defined and reused to create charts on your dashboard. Your company administrator defines the data cubes.

Block Title

Add a title for this block.

Block Filter Elements

Group By elements from the data cube. This determines which columns from the data cube definition will be used to group data for filtering.

2 Click Add to add Drilldown Details. The Edit Drilldown Details window opens.

 

   

In this field:

Do this:

Title

Enter a title for the drilldown.

Show Data From

Select the shells to use as data sources.

Display Type

Select the type of display, for example, a bar chart.

Source Grouped By

Select the columns from the data cube definition that will be used to group data.

Output Type

Select Record Count or Summary Value.

Report On

Select the columns from the data cube to be defined as Summary.

Summary Type

Select the summary type.

Show Result

Select the type of result, for example, Actual Value.

Show Total

Select to show the totals for the data.

Decimal Places

Select the number of decimal places.

Use 1000 Separator (,)

Select to use a comma (,) as a separator.

Negative Number Format

Specify the format for negative numbers.

Currency Format

Select the currency format.

3 Click OK, and click OK to exit the Edit Dashboard window.

 

 

 

 


Oracle Corporation

Primavera Unifier 9.10 • Copyright © 1998, 2012, Oracle and/or its affiliates. All rights reserved.

Copyright Information