Is there a way to display a measures without data?

For measures reports (say Measures - Previous vs. Current), is there way to display measures even when there is do data in the time range?

Currently the measure name does not appear if there is no data at all in a time range. If there is data in at least one time period, then the measure name is displayed and the "no data" (aka Ghostbusters’s) symbol appears where there is no data.

This is in contrast to objectives reports, in which the objective name will be displayed even if there is no data in the underlying measures.

This is not a showstopper for us, as we have a one for one relationship for measures and objectives so we can show an objective report. However Objective reports require an extra drill step, which is inconvenient.

Ideally it would be nice to have a setting to turn on or off display of measures that had no data in measure reports. That being said, I would much rather see product development effort reworking the loaders so that they are more user friendly over this.

Thanks in advance.

WF 7.65. Solaris. PMF 5.11 on Oracle 10g

Posts: 48 | Location: New York | Registered: March 25, 2009

Moogle

Guru

posted

Hide Post

Hi Seth,

We have an operational report for data that is not quite ready to be made into a proper measure. The client wanted to be able to call the report from within PMF and have it respect the drill-down context, even though there was no measure to drive this.

We solved this by loading zeros into PMF for every time period and dimension value. Now the user can drill-down on the zeros until they are at the desired time and dimension level, at which point they can call the external report through the Options button (custom coded link).

This would solve you issue too, in that the measure would always show.

Hope this helps a bit.

Cheers,

Joey

-WebFOCUS 8.2.01 on Windows

Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005

SethW

Silver Member

posted

Hide Post

Thanks Joey,

By happenstance I figured out that Analysis Designer created gadgets that do not have the date range set will display all dates. So as long as there is at least one value in a metric, the metric will be displayed on the report.

See sample code below:

-* File gadget_file_name.fex

-SET &PERSPECTIVE_ID=0;
-SET &OBJECTIVE_ID=0;
-SET &MEASURE_SERIES='0';
-SET &INWH33=0;
-SET &RPT_FLDIN01='IND_ACTUAL_TARGET_DEFAULT';
-SET &RPT_FLDIN02='VAL_ACTUAL';
-SET &RPT_FLDIN03='VAL_TARGET';
-SET &SORTACROSS='TIME_LEVEL03_VALUE';
-SET &REPORT_TITLE='Report_Title';
-SET &WFFMT='HTML';
-SET &THIS_FOCEXEC='PMF_RPT_TMPLT_MEAS_ACRDIM';
-INCLUDE PMF_RPT_TMPLT_MEAS_ACRDIM

WF 7.65. Solaris. PMF 5.11 on Oracle 10g

Posts: 48 | Location: New York | Registered: March 25, 2009

Ignored post by SethW posted

Show Post

Please Wait. Your request is being processed...