In several of the dimensional drill down reports we would like to be able to drill to an operational report -- however that option to "Drill to an operational report" is missing from the drill down dropdown menu. For example this occurs when navigating through dimensions from an analysis designer report. It looks like the analysis designer report calls a_meas_detail01.fex to do the dimensional slicing and dicing so this is the actual fex I am referring.. Basically in the dropdown menu all that is available are dimensions -- we would like to see operational report on this list as well. That way we can pass as parameter the current dimensional cross sections and levels to an operational report.

As it stands now, the user has to go back to the top level Analysis designer report and then drill to an operational report -- which would not pass the identified dimensional cross section and levels.

Any assistance on how to add an “operational report” to the dropdown list on a_meas_detail01.fex would be appreciated. It looks like the dimensional cross section information is in the breadcrumbs at the bottom of the a_meas_detail01 report. Adding operational report to the options button list did not meet the user requirements, but adding a third button (back, options, operational report) may be an acceptable alternate solution if it is not possible to add “operational report” to the dimensional drilldown list.

Thanks in advance.

-Seth

Hi Seth--
You'll see the operational dropdown on the measure name column.

On dimension values in these reports, you see only cross-drills to dimensions. There's a reason for this. You couldn't drill on those to display an operational report because the measure isn't known for dimensional drills (they are to the left and outside the measure name, and there's only one drill for multiple measures). Operational reports are linked to the measures themselves, so the measure ID has to be known inside the drill.

Of course there is a solution but it involves a customization. If you wanted dimensional drills to contain the operational report drill would be a customization. You coudl alter the core dimension drill code to add operational report. Your reports would have to repeat the dimension value for every row, so that each row linked to a different measure would contain the measure ID. You'd also need to alter the reports to pass the measure ID on the dimension value columns. Both of those pieces in place would give you what you want.

Hope this makes sense; let us know if this doesn't answer your question.

thanks

Hi Seth,

If you'd like this done just for the measures detail report you could customize it by doing the following.

Try the below code snippet to do what you'd like.

In a_meas_detail01.fex:

-* Current code
-SET &THIS_DRILL_COL = 'B1' ;
-INCLUDE A_GET_DRILL_DOWN
$

-* Change this code to
-SET &THIS_DRILL_COL = 'B1' ;
-INCLUDE A_GET_DRILL_DOWN
-* Add this new section below
DRILLMENUITEM=&MD_OPRPT.QUOTEDSTRING, FOCEXEC=run_launch_page( \

-* Depending on the column that was drilled on, define that we passed SORTBY1, SORTBY2, SORTACROSS or DATA
-SET &DRILLFIELD = IF (&THIS_DRILL_COL EQ 'B1') THEN &SORTBY1
- ELSE IF (&THIS_DRILL_COL EQ 'B2') THEN &SORTBY2
- ELSE IF (&THIS_DRILL_COL EQ 'A1') THEN &SORTACROSS
- ELSE IF (&THIS_DRILL_COL EQ 'DATA') THEN 'DATA'
- ELSE ' ' ;

DRILL_NAME = &DRILLFIELD.QUOTEDSTRING \
DRILL_COL = &THIS_DRILL_COL.QUOTEDSTRING \

-INCLUDE A_GET_DRILL_DOWN_PARMS

-IF (&STYLESHEET_ID_B1 EQ ' ') THEN GOTO :A_GDDM_SK0A ;
DRILL_VAL1 = &STYLESHEET_ID_B1 \
-:A_GDDM_SK0A

-IF (&STYLESHEET_ID_B2 EQ ' ') THEN GOTO :A_GDDM_SK0B ;
DRILL_VAL2 = &STYLESHEET_ID_B2 \
-:A_GDDM_SK0B

-IF (&STYLESHEET_ID_A1 EQ ' ') THEN GOTO :A_GDDM_SK0C ;
DRILL_VAL3 = &STYLESHEET_ID_A1 \
-:A_GDDM_SK0C

MEASURE_SERIES = &MEASURE_SERIES), TARGET=&PMF_DRLL_TGT,

$

Cheers,
Mike

THANK YOU MICHAEL!!! I just tried out your proposed code change, and it looks like this works beautifully.

I really appreciate the assistance.


Note: It looks like it is taking the parameters from the dimensional cross section and levels from the breadcrumbs at the bottom of the page -- not the dimensional cross section and level that you drill on. This is still by far a lot better than having to go back to the originating report to drill out to an operational report.

-Seth

This message has been edited. Last edited by: SethW,