I have a challenge that does not seems to be possible to res...

[Martin Yergeau]

I have a challenge that does not seems to be possible to resolve.

Ive search the doc and tried several coding options, but cannot make it work.

My challenge is to add a drill option to the matrix rows and columns.

I can create a drill down from the measure (DOLLARS) and have the detail of the intersection of the State & Category.

But I would like to add a drill down on the State (e.g. FL) to have all the Categories & Products related to that State.

Same for Category, where I can have all the States related to that product category

Here sample code

ENGINE INT CACHE SET ON

SET PAGE-NUM=NOLEAD

SET ARGRAPHENGINE=JSCHART

SET EMBEDHEADING=ON

SET GRAPHDEFAULT=OFF

-DEFAULTH &WF_STYLE_UNITS='PIXELS';

-DEFAULTH &WF_STYLE_HEIGHT='405.0';

-DEFAULTH &WF_STYLE_WIDTH='770.0';

-DEFAULTH &WF_TITLE='WebFocus';

 

GRAPH FILE GGSALES

SUM DOLLARS

BY ST

BY CATEGORY

BY PRODUCT

ON GRAPH PCHOLD FORMAT JSCHART

ON GRAPH SET VZERO OFF

ON GRAPH SET GRWIDTH 1

ON GRAPH SET AUTOFIT ON

ON GRAPH SET UNITS &WF_STYLE_UNITS

ON GRAPH SET HAXIS &WF_STYLE_WIDTH

ON GRAPH SET VAXIS &WF_STYLE_HEIGHT

ON GRAPH SET LOOKGRAPH LINE

ON GRAPH SET AUTOFIT ON

ON GRAPH SET STYLE *

*GRAPH_SCRIPT

setPieDepth(0);

setPieTilt(0);

setDepthRadius(0);

setPlace(true);

setCurveFitEquationDisplay(false);

setUseSeriesShapes(true);

*END

INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$

TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $

TYPE=DATA, COLUMN=N1, BUCKET=row, $

TYPE=DATA, COLUMN=N2, BUCKET=column, $

TYPE=DATA, COLUMN=N3, BUCKET=x-axis, $

TYPE=DATA, COLUMN=N4,

BUCKET=y-axis,

FOCEXEC=IBFS:/WFC/Repository/Public/Target_Rpt.fex (ST=N1 CATEGORY=N2),

TARGET='_blank',

$

*GRAPH_SCRIPT

setReportParsingErrors(false);

setSelectionEnableMove(false);

setDisplay(getY1Title(),false);

setDisplay(getO1Title(),false);

setAxisSide(getO1Axis(),1);

setBorderColor(getY1ZeroLine(),new Color(0,0,0));

setLineWidth(getY1ZeroLine(),1);

setFillColor(getSeries(*),new Color(7,96,73));

*GRAPH_JS_FINAL

"matrixProperties": {

"rowLabels": {

"font": "bold 10pt Sans-Serif",

"color": "black",

},

"colLabels": {

"font": "bold 10pt Sans-Serif",

"color": "black",

},

"rowHeader": {

"font": "16pt Sans-Serif",

"color": "rgb(8,97,74)",

},

"colHeader": {

"font": "16pt Sans-Serif",

"color": "rgb(8,97,74)",

},

"cellBorder": {

"width": 1,

"color": "rgb(6,127,190)",

"dash": ""

},

"minCellSize": "auto"

},

"xaxis": {

"title": {

"visible": false

}

},

"pieProperties": {

"holeSize": "0%"

},

"blaProperties": {

"seriesLayout": "absolute"

},

"yaxis": {

"title": {

"visible": false

}

},

"agnosticSettings": {

"chartTypeFullName": "Line_Absolute"

}

*END

ENDSTYLE

END

-RUN

[Manoj Chaurasia]

Martin

It appears that WebFOCUS doesnt allows drill downs on Matrix objects only the Axis fields.

[Martin Yergeau]

This what I thought, but since sometime we can arrange workaround Id prefer asked

Thanks Chuck to confirm

[Martin Yergeau]

I finally found a work around

Ive added two DrillMenuItem where in one I instead pass _FOC_NULL as the ST value and in the second its in Category that I pass _FOC_NULL.

Then, adjusting the target report accordingly I can have all ST from a selected Category or vice versa.