Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Ben Maxwell

Recommended Posts

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.

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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, $

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...