Bar graph - no drill down?

quote:
$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N1 LE 0,
$
DEFMACRO=COND0002,
MACTYPE=RULE,
WHEN=N1 LE -.20,
$

I wonder why you have this conditional styling.
if you remove it, is it still not working?

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006

Ignored post by FrankDutch posted

Master

posted

took out the conditions, and it still does not drill down.

Good idea, though.

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

Posts: 611 | Registered: January 04, 2007

Ignored post by Jason K. posted

<JG>

posted

Works fine in 76

Perhaps your problem is the line

FOCEXEC=app/pulsesal.fex(FACILITY_CODE=A1),

try using the real column name instead of A1

Your code should read

FOCEXEC=app/pulsesal.fex(FACILITY_CODE=FACILITY_CODE),

This message has been edited. Last edited by: <JG>,

Master

posted

That was an excellent idea JG, so I tried this...
FOCEXEC=app/pulsesal.fex(FACILITY_CODE=FACILITY_CODE),

still, no drill down.

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

Posts: 611 | Registered: January 04, 2007

Ignored post by Jason K. posted

<JG>

posted

Jason I changed the post slightly but same meaning.

Do you get the mouse over for the drilldown?
Any errors if you view source on the html page?

Master

posted

no, no mouseover event handler.

In fact, here's my entire source... not very long.

<HTML>

<HEAD>

<TITLE>Powered by WebFOCUS</TITLE>

</HEAD>

<BODY BGCOLOR="ffffff">

<MAP NAME=xivaufhx0>

<AREA SHAPE=POLYGON COORDS="236,157,269,157,269,107,236,107"

NAME=" PS -.36"

TITLE=" PS -.36"

NOHREF

ALT=" PS -.36">

<AREA SHAPE=POLYGON COORDS="195,189,228,189,228,107,195,107"

NAME=" NE -.59"

TITLE=" NE -.59"

NOHREF

ALT=" NE -.59">

<AREA SHAPE=POLYGON COORDS="154,107,187,107,187,103,154,103"

NAME=" ID .03"

TITLE=" ID .03"

NOHREF

ALT=" ID .03">

<AREA SHAPE=POLYGON COORDS="113,118,146,118,146,107,113,107"

NAME=" HC -.08"

TITLE=" HC -.08"

NOHREF

ALT=" HC -.08">

<AREA SHAPE=POLYGON COORDS="72,154,105,154,105,107,72,107"

NAME=" CS -.34"

TITLE=" CS -.34"

NOHREF

ALT=" CS -.34">

<AREA SHAPE=POLYGON COORDS="31,107,64,107,64,47,31,47"

NAME=" BB .43"

TITLE=" BB .43"

NOHREF

ALT=" BB .43">

<AREA SHAPE=default NOHREF>

</MAP>

<IMG SRC="/ibi_apps/WFServlet?&PG_Func=GETBINARY&PG_File=lvrgrkpi.png" USEMAP="#xivaufhx0" BORDER=0 ALT=""><br>

<BR>

</BODY>

</HTML>

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

Posts: 611 | Registered: January 04, 2007

Ignored post by Jason K. posted

Francis Mariani

Expert

posted

Have you tried a simple GRAPH test?

GRAPH FILE CAR
SUM
SALES
ACROSS COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=N1, FOCEXEC=GRTEST1(COUNTRY=N1), $
ENDSTYLE
END

If this works, keep adding code, one line at a time, until is stops working. It may be easier to solve the problem this way.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

<JG>

posted

For some reason WebFocus is not generating the html correctly

you should see an href such as below for each polygon (bar) that is displayed

 HREF="/ibi_apps/WFServlet?IBIF_webapp=%2Fibi_apps&IBIC_server=EDASERVE&IBIAPP_app=baseapp
&IBIF_ex=app%2Fpulsesal.fex&CLICKED_ON=UNSET%20PARAMETER&FACILITY_CODE=PS&"

Try chaging the drilldown to

TYPE=DATA,
COLOR=RGB(77 196 136),
FOCEXEC=app/pulsesal.fex(FACILITY_CODE=FACILITY_CODE),
$

I've tested it in both 760 and 710, both work fine

Francis Mariani

Expert

posted

quote:
TYPE=DATA,
COLOR=RGB(77 196 136),
FOCEXEC=app/pulsesal.fex(FACILITY_CODE=FACILITY_CODE),
$

You'll need to specify which sub-component you want to apply the drilldown to: ACROSSCOLUMN=N1 (ACROSSCOLUMN=COUNTRY will not work).

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

<JG>

posted

Francis you do not need the ACROSSCOLUMN component, works fine just using TYPE=DATA as you only have 1 element.

HOWEVER I made a mistake switching my configurations and was using the 71 client with the 76 server

IT DOES NOT WORK IN 710 but does in 76, so I think a case with IBI is needed

Here's a car file based version.

Any one out there able to test on 716/717

GRAPH FILE CAR
SUM COMPUTE sales_diff/D12.2=( DEALER_COST - RETAIL_COST ) / DEALER_COST; AS ''
ACROSS COUNTRY
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 280
ON GRAPH SET HAXIS 300
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setFillColor(getLegendArea(),new Color(230,230,230));
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,1);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),2);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setSubtitleString("MTD % of Goal");
setTextJustHoriz(getSubtitle(),1);
setFontSizeAbsolute(getSubtitle(),true);
setFontSize(getSubtitle(),12);
setFontStyle(getSubtitle(),3);
setTextRotation(getSubtitle(),0);
setTextWrap(getSubtitle(),false);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlaceResize(getSubtitle(),0);
setPlaceRotate(getSubtitle(),0);
setPlaceAlign(getSubtitle(),0);
setPlaceWordWrap(getSubtitle(),0);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N1 LE 0,
$
DEFMACRO=COND0002,
MACTYPE=RULE,
WHEN=N1 LE -.20,
$
TYPE=REPORT,
GRAPHCOLOR='WHITE',
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR=RGB(234 236 255),
BACKCOLOR=RGB(230 230 230),
STYLE=NORMAL,
RIGHTGAP=0.125000,
$
TYPE=DATA,
COLOR=RGB(77 196 136),
FOCEXEC=CARINST(COUNTRY=COUNTRY),
$
ENDSTYLE
END

Master

posted

interestingly, this works...
GRAPH FILE CAR
SUM
SALES
ACROSS COUNTRY
ON TABLE SET STYLE *
TYPE=DATA,
COLOR=RGB(77 196 136),
FOCEXEC=app/pulsesal.fex(FACILITY_CODE=FACILITY_CODE),
$
ENDSTYLE
END

That tells me a lot.
I'll post in a few.

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

Posts: 611 | Registered: January 04, 2007

Ignored post by Jason K. posted

Master

posted

now I'm making headway using Francis's suggestion.

I took his simple CAr file code and started cutting/pasting from my faulty fex into it.

the
SUM COMPUTE SALES_DIFF/D12.2 = (SALES * 1); AS 'X'

makes it stop drilling down.

if I just leave it as SUM SALES it drills down just fine.

I don't know what to do next.

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

Posts: 611 | Registered: January 04, 2007

Ignored post by Jason K. posted

mgrackin

Virtuoso

posted

Try:

SUM SALES NOPRINT

Then:

COMPUTE SALES_DIFF...

Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011

Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003

Ignored post by mgrackin posted

<JG>

posted

pre-process the output step.

TABLE FILE D_STG_DETAIL
SUM COMPUTE sales_diff/D12.2=( SALES - SALES_GOAL ) / SALES;
BY FACILITY_CODE
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS GDATA
END
-RUN

Your graph part of the request then becomes

GRAPH FILE GDATA
SUM sales_diff AS ''
ACROSS FACILITY_CODE
etc.

Should work.

Compute did cause a number of issues in graphs up until very recently

Master

posted

I tried what mgrackin suggested against the car file. Does it work for anyone else, nothing for me. Maybe it's just a setup thing.

GRAPH FILE CAR
SUM SALES NOPRINT
COMPUTE SALES_DIFF/D12.2 = (SALES * 1); AS 'X'
ACROSS COUNTRY
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 280
ON GRAPH SET HAXIS 300
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setFillColor(getLegendArea(),new Color(230,230,230));
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,1);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),2);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setSubtitleString("MTD % of Goal");
setTextJustHoriz(getSubtitle(),1);
setFontSizeAbsolute(getSubtitle(),true);
setFontSize(getSubtitle(),12);
setFontStyle(getSubtitle(),3);
setTextRotation(getSubtitle(),0);
setTextWrap(getSubtitle(),false);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlaceResize(getSubtitle(),0);
setPlaceRotate(getSubtitle(),0);
setPlaceAlign(getSubtitle(),0);
setPlaceWordWrap(getSubtitle(),0);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N1 LE 0,
$
DEFMACRO=COND0002,
MACTYPE=RULE,
WHEN=N1 LE -.20,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR=RGB(234 236 255),
BACKCOLOR=RGB(230 230 230),
STYLE=NORMAL,
RIGHTGAP=0.125000,
$
TYPE=DATA,
COLOR=RGB(77 196 136),
FOCEXEC=app/pulsesal.fex(FACILITY_CODE=FACILITY_CODE),
$
ENDSTYLE
END

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

Posts: 611 | Registered: January 04, 2007

Ignored post by Jason K. posted

Master

posted

thanks JG, I'll go back and modify our the view on the database to handle the change if that's the only way that it can be done.

What I'm gathering from this... you can't aggregate a compute and expect a drill down.

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

Posts: 611 | Registered: January 04, 2007

Ignored post by Jason K. posted

<JG>

posted

You need to dump the compute from the graph request. see the post just before your last one.

update as you replied so quickly.
compute and a number of other things were always an issue in graphs but are sorted in the newest releases.

You do not need to modify the view just pre-process.

mgrackin

Virtuoso

posted

I have WF713 and I tried to run this. IT DOES NOT WORK with WF 713.

I recommend two things:

1) Open a case with IBI

2) Go with JG's suggestion.

Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011

Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003

Ignored post by mgrackin posted

Francis Mariani

Expert

posted

Yes, it looks like drilldowns on computed fields in a graph do not work. Curious.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted