Is there a way for a graph to display a dynamic Header based...

[Ben Maxwell]

Is there a way for a graph to display a dynamic Header based on the autodrill selection This is something I am trying in AppStudio 8.206.

 

In this example I would want Widget to appear as the graph header

 

 

 

If I would drilldown into Division, lets say I had 3 divisions called Wakko, Yakko, and Dot. I would want to see those Division Names in the page headers for those graphs.

[Warren Hinchliffe]

If you drill down from somewhere else and the value of the drill is the Division, there should be an amper variable that will contain the passed Division. You should be able to add this to the header.

Check what parms are passed tot he chart.

[Ben Maxwell]

Lets see is these screenshots better illustrate my issue

 

If I click and drag the Company field into the Graph header, it will bring in the Companys Name into all headers regardless of drilldown level

 

 

image.png849336 40.6 KB

 

Result of graph - (At the top level the header is correct)

 

Drilldown to the Drilldown Level from the Actual dataset

Company A appears in all of the headers. What I would really want to happen is -

Graph 1 header = Medicine Division

Graph 2 header = Pediatrics Division

Graph 3 header = Surgery Division

 

image.png408537 22.9 KB

 

So the question is how do I at the high level of graphs set the Header to Company, and then upon the first drilldown set the Header to Division (and not Company)

[Manoj Chaurasia]

Benjamin

The problem is you are using the COMPANY field in the header. Waz is on the right track to reference the parameter instead of the field.

[Lucky .]

When you drilldown to Surgery Division the graph data shows only Surgery related data right so use same amper value that you are using to filter the data for surgey division in the header as well. This will give you same header division title as ur data.

Example: WHERE DIVISION EQ &GRA_DIV;

Use &GRA_DIV in your header as well. This will resolve your issue.

[Ben Maxwell]

Im still having some struggles with these dynamic page headers.

So lets reload, and walk through an example I created based off of the Movies.mas.

This is my graph

 

image.png1033613 32.6 KB

 

Page header is set to

 

When I run this I get -

 

Ill run this for the Action genre

This is the proper header at this point

 

When I drilldown into Rating I see this

 

Id prefer to see PG in the first chart and R in the second chart

My question is, is there something I am missing which will make that header dynamic based on the level of Auto-drill you are in

[Lucky .]

Can you post the code for above graph

[Ben Maxwell]

Here is the code I used to run the graph.

Note : I stripped out the Internal Comment Lines.

Also you will notice that the file is called MOVIES_1. I created a copy of the MOVIES master file, and applied a business view so I can play with the Auto-Drill.

ENGINE INT CACHE SET ON

SET PAGE-NUM=NOLEAD

SET ARGRAPHENGINE=JSCHART

SET EMBEDHEADING=ON

SET GRAPHDEFAULT=OFF

-DEFAULTH &WF_TITLE=WebFOCUS Report;

GRAPH FILE movies_1

-* Created by Info Assist for Graph

SUM MOVIES_1.MOVINFO.COPIES

BY MOVIES_1.MOVINFO.CATEGORY NOPRINT

WHERE MOVIES_1.MOVINFO.CATEGORY EQ &CATEGORY.(FIND MOVIES_1.MOVINFO.CATEGORY IN BV/MOVIES_1 |FORMAT=A8,SORT=ASCENDING,REQUIRED=TRUE).CATEGORY:.QUOTEDSTRING;

HEADING

&CATEGORY

ON GRAPH PCHOLD FORMAT JSCHART

ON GRAPH SET VZERO OFF

ON GRAPH SET GRWIDTH 4

ON GRAPH SET HAXIS 238.0

ON GRAPH SET VAXIS 175.0

ON GRAPH SET LOOKGRAPH BAR

ON GRAPH SET STYLE *

*GRAPH_SCRIPT

setPieDepth(0);

setPieTilt(0);

setDepthRadius(0);

setPlace(true);

setCurveFitEquationDisplay(false);

*END

INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$

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

TYPE=HEADING, JUSTIFY=CENTER, $

TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT=Trebuchet MS, SIZE=12, COLOR=RGB(66 70 73), STYLE=BOLD, $

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

TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $

*GRAPH_SCRIPT

setReportParsingErrors(false);

setSelectionEnableMove(false);

*END

ENDSTYLE

END

-RUN

-*IA_GRAPH_FINISH

[Manoj Chaurasia]

It would be nice to get your master file as well so we can test with exactly what you have.

[Ben Maxwell]

Any idea if there are any master files in one of these folders which contains an example of a Business View which utilizes a hierarchy

 

My specific issue comes from trying to create dynamic page headers based on the level of the auto-drill.

[Manoj Chaurasia]

Benjamin

I am not aware of any business views in the sample data. Please post your modified master file for movies_1

[Ben Maxwell]

Heres the code for my Business View of the movie master file.

indent preformatted text by 4 spaces

FILENAME=MOVIES_1, SUFFIX=FOC , BV_NAMESPACE=OFF, $

SEGMENT=MOVINFO, SEGTYPE=S1, $

FIELDNAME=MOVIECODE, ALIAS=MCOD, USAGE=A6, FIELDTYPE=I, $

FIELDNAME=TITLE, ALIAS=MTL, USAGE=A39, $

FIELDNAME=CATEGORY, ALIAS=CLASS, USAGE=A8, $

FIELDNAME=DIRECTOR, ALIAS=DIR, USAGE=A17, $

FIELDNAME=RATING, ALIAS=RTG, USAGE=A4, $

FIELDNAME=RELDATE, ALIAS=RDAT, USAGE=YMD, $

FIELDNAME=WHOLESALEPR, ALIAS=WPRC, USAGE=F6.2, $

FIELDNAME=LISTPR, ALIAS=LPRC, USAGE=F6.2, $

FIELDNAME=COPIES, ALIAS=NOC, USAGE=I3, $

FOLDER=MG_MOVINFO, PARENT=.,

DV_ROLE=MEASURE,

DESCRIPTION=Measure Groups, $

FOLDER=DIM_MOVINFO, PARENT=.,

DV_ROLE=DIMENSION,

DESCRIPTION=Dimensions, $

FOLDER=MOVINFO, PARENT=MG_MOVINFO,

DESCRIPTION=Movinfo, $

FIELDNAME=WHOLESALEPR, BELONGS_TO_SEGMENT=MOVINFO, $

FIELDNAME=LISTPR, BELONGS_TO_SEGMENT=MOVINFO, $

FIELDNAME=COPIES, BELONGS_TO_SEGMENT=MOVINFO, $

FOLDER=MOVINFO1, PARENT=DIM_MOVINFO,

DESCRIPTION=Movinfo, $

FIELDNAME=MOVIECODE, BELONGS_TO_SEGMENT=MOVINFO, $

FIELDNAME=TITLE, BELONGS_TO_SEGMENT=MOVINFO, $

FIELDNAME=CATEGORY, BELONGS_TO_SEGMENT=MOVINFO, $

FIELDNAME=DIRECTOR, BELONGS_TO_SEGMENT=MOVINFO, $

FIELDNAME=RATING, BELONGS_TO_SEGMENT=MOVINFO, $

FIELDNAME=RELDATE, BELONGS_TO_SEGMENT=MOVINFO, $

FOLDER=DIMENSION1, PARENT=DIM_MOVINFO,

DESCRIPTION=MovieHierarchy, $

FIELDNAME=CATEGORY, BELONGS_TO_SEGMENT=MOVINFO,

DV_ROLE=LEVEL, $

FIELDNAME=RATING, BELONGS_TO_SEGMENT=MOVINFO,

DV_ROLE=LEVEL, $

[Manoj Chaurasia]

Benjamin

Sorry for the delayed response I took your master and added DIRECTOR to the hierarchy so there were more levels to drill to. What I see is that it shows a crumb trail of the drill down under the Directors name. I believe that is how it is designed to work.

 

image.png15921011 61.3 KB